Start of Content Area

Object documentation Oracle Session Monitor Locate the document in its SAP Library structure

Definition

This submonitor in the SAP/Oracle Database Monitor lets you check the Oracle session list and related resource information. In addition, you can see an execution plan and the SQL statement performed by a session.

Use

You choose Detailed Analyses ®  Resource Consumption ® Oracle Session Monitor.

You can view history information in this monitor.

Structure

This screen contains the following information:

Column

Description

Instance Id

Database instance ID

Inst. Name

Instance name

SID

Session ID

ORA proc.

Oracle shadow process ID

SAP instance name

SAP instance name

Clnt system

Client system

Clnt proc.

Client process

Status

Session status

Event

Event name

SQL Text

Text of SQL statement

You can double-click a row to display the detail screen with the complete SQL statement. From the detail screen you can choose Explain SQL statement to display the execution plan

Integration

This monitor is based on the following views:

End of Content Area