Manage Oracle user sessions
To open a session management window in the DB:
Button on the main window [sessions]
Menu [Action - Sessons]
In Query Editor, in the tree of objects [double click on the sessions]
For more information about the session, you must select it in the list.
For a list of available sorting by columns.
For more information sessions available:
Opening of the session cursors
Request text (current)
Additional information in cases where the request has more than 5 seconds (Longops)
The query plan
Using the rollback segments
For a list of available sessions 4 filters:
It does not belong to the database (user)
List of "Parallel session"
Displays information about processes running in parallel, execution statistics
List "Blocking TREE"
Tree of locks. The uppermost blocking session, sessions lower than expected
1. Update the data (current sheet)
2. Open Query Editor
3. Open the "Active session"
4. End the current session (highlighted in the list)
5. Enable tracing for the selected session
6. Disable tracing for the session
If you disable the session tracing should be noted that this follow these steps:
Select the session in the list of "Eracing is enabled for" and only then disable tracing