Retrieving Information about Current Sessions

Last modified: October 23, 2019

To retrieve the information about current sessions simply select Session Manager on the Database menu. All database sessions will be displayed in the grid, containing 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 the 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 Studio 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.

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.