Session Detail(9.1)

Addrhash

Character string that identifies the SQL statement being executed

Blocking Locks

Number of locks that are blocking other locks

Command

Command being executed. To display the SQL Text(4.0) report, choose this field.

Container ID

The ID of the container to which this session belongs.

This field is valid if the monitoring target is Oracle Database 12c R2 or later in a CDB configuration.

Otherwise, the value is 0.

Locks Held

Number of locks held during data collection

Open Cursors

Number of open cursors. To display the Open Cursors(4.0) report, choose this field.

Program

Name of the program being executed

Session Events

Number of events the session is waiting for

Session Waits

Number of resources and events the session is waiting for

Sessions Blocked

Number of sessions that have been placed in wait status by this session

SID

Session ID. To display the Session Statistics Detail(4.0) report, choose this field.

Table Accesses

Number of table accesses

Transactions

Number of active transactions

User

Oracle user name

Open Cursors(4.0)

Displays detailed information about the open cursors in the session. To display this report, choose the Open Cursors field.

Session Statistics Detail(4.0)

Displays detailed statistical information about a session. To display this report, choose the SID field.

SQL Text(4.0)

Displays the performance data in the SQL Text and Explain Plan fields. To display this report, choose the Command field.