Retrieving Information about Current Sessions
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.
Want to Find out More?
Overview
All features
Request a demo
