<< Click to Display Table of Contents >>

Overview Sessions

Top Previous Next

Overview Sessions is the default sheet. You see a list of all sessions in the database, including:


Aud SID, i.e. userenv(SESSIONID)

Oracle user

Operating system user

Program name


Event being waited for

Number of locks being held

Number of locks being requested

Oracle process number

Operating system process id

Logon time

Client terminal

Client machine

Operating system client process id

Module (dbms_application_info)

Action (dbms_application_info)

Client info (dbms_application_info)

Inactive sessions are displayed in gray.

A session that is holding a lock and is blocking another session is shown in red. A session that is holding a lock, but is currently not blocking another session, continues to be shown in black type.

Click on the Overview tab to refresh the display or use the auto-refresh button in the status bar for session monitoring.

The editor control at the bottom of the window displays the active (or last executed) SQL statement from the current (active/inactive) session. It depends on the server how long information about inactive sessions can be retrieved.

The following context operations are available:


Kill session



Kills a session.


Disconnect session



Disconnects a session from the server.


Switch Consumer Group



Transfers the session to another consumer group


SQL trace



Toggles SQL Trace for the session. You may then use Oracle's TKPROF utility to view the trace file.






Grid View



For more information, see object window

The edit box to the right of the Overview sessions header shows the status of login allowance. Use the ellipsis button to enable or disable a restricted session.