4.9 Session Manager
This tool is used to manage the connections made to the database.
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.
Toolbar
The toolbar contains the following commands.
- Refresh
- Refresh the view from the database.
- Filter
- Here you can define which sessions to display. You can choose to see only sessions of specific users, only active sessions, all sessions, all sessions except background or all sessions except system ones.
- 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.
- Select all sessions
- TODO
- Deselect all sessions
- TODO
- Filter
- TODO
- Change connection
- Change the connection to administrate storage for.
Inspecting a session
When you select a session the following information is available in the tabbed pane at the bottom of the window.
- Current statement
- The statement that is currently being executed (see sgastatement for information about the statement).
- Long ops
- TODO
- 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.
- Wait events
- TODO
- 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.
- Accessing
- TODO
- Previous statement
- The next to last statement being executed by the session (see sgastatement 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.