Retrieving Information about Current Session

To retrieve the information about current sessions simply select Session Manager in Oracle on the Fusion menu. All database sessions will be displayed in the grid containing the following fields:

User Name - Name of the user associated with the session.

Sid - Session identifier.

Serial - Session serial number, used to unambiguously determine a session. In combination with the Sessions ID, it is used to specify the correct session to manipulate with.

Status - Shows whether a user session is active, inactive or killed.

OS User - Operating system username.

Machine - Operating system machine through which the user is connected.

Program - Program you are currently running.

Schema Name - Schema name associated with the user.

SQL Address, SQL Hash Value - Used to identify the SQL statement that is currently being executed.

Logon Time - Shows the start date and time of the session.

Clicking the Refresh button refreshes the information in grid.

Columns order can be specified by user. To call Customize Columns window click the Customize session columns button on the toolbar. To show/hide the column select/deselect the corresponding check box left of the column name in the window. To change columns order drag the required column to the desired location. Click OK to apply changes.

dbForge Fusion gets information about sessions in the grid from the SYS.V$SESSION view. To get all SYS.V$SESSION columns, click the Full Session Information button on the Session Manager toolbar. Visit Oracle Database Reference for an information about fields of this view.

At any time you can use filtering, sorting and grouping session data in the grid and resize grid columns.

Detailed statistics is available for each session. It is contained on the Statistics tab below sessions list.