The session tool consists of a toolbar, a list displaying the connections currently open to the database and at the bottom a tabbed pane where you can investigate a specific connection to the database.
Refresh | Refresh the view from the database. |
Enable timed statistics | Enable timed statistics for the currently selected session. |
Disable timed statistics | Disable timed statistics for the currently selected session. |
Disconnect session | Disconnect the currently selected session. You will be asked if you allow the current transaction to finish before kicking the session out or not. |
Refresh time | A list where you can select the interval between automatic updates. |
Change connection | Change the connection to administrate storage for. |
Statistics | The session statistics available for the session. You will get more statistics if you enable timed statistics through the toolbar. There are also two charts displaying waitstates and I/O for the selected session. |
Connection info | Information about the connection and versions of the components used. |
Pending locks | What locks this session is currently waiting for. |
Locked objects | The objects currently locked by this session. |
Current statement | The statement that is currently being executed. See SGA statement for information about the statement. |
Previous statement | The next to last statement being executed by the session. See SGA statement for information about the statement. |
Open cursors | This contains a list of all the cursors currently held open by the session. When a statement is selected in the list you can investigate it using the normal SGA statement view. |