Statement Level Tabs
The following parameter sets describe statement-level properties:
Activity tab- Full statement syntax; The Resource Breakdown pie chart reflects all activity from its start to end or to the present if the statement is still active.
Statistics tab- The drop down listing (of cumulative statistics since the beginning of statement execution or to the present if the statement is still active) allows for a choice of either:
Oracle Detailed Statistics: standard V$SESSTAT statistics, grouped by class.
Oracle Extended Statistics: calculated expert statistics
Blocking Locks tab- Listing of the locks (and their corresponding sessions) that are blocking (or blocked) the statement during the course of its execution. An active lock that is currently blocking the statement is indicated with an (
) icon.
|
Column |
Description |
|
SID |
SID of the blocking session. Click the SID to drilldown into the blocking session and trace its activity. In the case of an active lock, the actual blocking statement can be discovered by looking at the current active cursor in the Open Cursors tab. |
|
Serial |
Serial number identifying the blocking session |
|
DB User |
Oracle user under which the session is running |
|
Server PID |
Process ID of the blocked session server process |
|
Object Wanted |
Database object on which the lock took place |
|
Lock Time |
Date and time when the blocking began |
|
Duration in Time Range |
Amount of time the lock took place within the displayed period (denominated in accordance with the totaling method in effect |
Datafile I/O tab- Display a lower pane listing of the files on which the statement performed most of the I/O.
Note: For storage systems based on EMC arrays, right-click a file of interest to analyze the file within Storage Analysis for EMC.