<< 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:

SID

Aud SID, i.e. userenv(SESSIONID)

Oracle user

Operating system user

Program name

Status (ACTIVE, INACTIVE, KILLED)

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:

SessionKill

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

Enable

On

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

 

 

DISABLE

Off

 

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.