Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How to identify session id jira in oracle database

Jira user started deletion, how to determine his session id in oracle database?

1 answer

0 votes
Benjamin Community Leader May 30, 2022

HI @Marina_Zavalishina ,


What kind of deletion was this Jira user doing that you want to track? I'm not sure if you can get that info from the DB. However, there is an audit log in Jira if you need to track certain object deletion.



Hi Ben, thanks for the answer, the user at the beginning of the deleted pages closed jira, but the session hung and the deletion was restored, had to restart jira. Since it was not possible to determine the user's session in the database in order to kill only his session, then it would be necessary to catch how to find and happen to the session in jira session in the database?

Benjamin Community Leader May 31, 2022

Hi @Marina_Zavalishina ,


What pages are you referring to in Jira? Usually pages and spaces are in reference to confluence. I'm not aware if there's a way to find all the actions that happen for a user in the DB. However, you can find some information form the audit log of what the user has done and to search the userid in the logs.



I need to identify the user session in the database in order to force it to close from the database.

jira-settings-system-Sessions of current users in Jira.
These sessions can be seen through the web interface, but how to look in the database, in which table is this information located?

Suggest an answer

Log in or Sign up to answer

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you