# 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 contain the following commands.

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.

## Inspecting a session

When you select a session the following information is available in the tabbed pane at the bottom of the window.

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.