Reviewing Locks Activity at the Instance Level
The Activity Locks panel, which displays lock summary information for an Oracle instance, comprises the following panes:
Locks Historical Tree
The Locks Historical Tree pane displays the locks activity and the locks tree summary, plotted over time.
This pane includes the sections listed below.
Viewing Detailed Sessions Data
The Sessions screen allows you to trace the activity of all currently connected sessions, as well as their resource consumption.
This panel can also be used to carry out the tasks described in the following sections:
The Current section in the top of the screen allows you to view current Key Performance Indicators of the monitored instance:
The Last 1 hour trend presents the activity on the instance during the last 1 Hour by presenting:
The current sessions table allows you to monitor the currently running sessions and their individual resource consumption. The Session List section contains a table that lists all currently running sessions, displaying each session in a separate row.
The Sessions view in the table can be filtered by the Active only and Foreground Only check boxes:
The various sections of the Session Drill Down page provide detailed information about the selected session upon selecting a specific session in the table.
The left section of the screen displays several parameters that provide general information about the selected session, as follows:
Waiting On — The current wait event on which the session is waiting.
The Workload chart displays the selected session workload (Average Active Sessions) during the specified time range (default 1 Hr.). The breakdown displays the workload, distributed by the various wait event categories. The colors of the categories match the colors of the various resources displayed in the Resource Breakdown section.
By clicking the Top Wait Events link at the upper right corner of the section, The Active Wait Events popup appears, with the Resource drop-down list unfiltered and displaying the entire list of wait events.
This tab provides details about the SQL statements that were executed by the selected session during the selected time range (up to 1 hour).
Additional statistics are displayed in the “Session Statistics” tab.
The Session Blocks pane displays all blocks held or requested by the selected session.
Viewing Datafiles I/O Activity at the Cluster Level
The Overall Datafiles I/O panel displays the I/O activity of all datafiles on the cluster. This panel includes the following sections:
The Physical I/O chart displays the physical I/O activity within the cluster’s datafiles, in either of the following methods:
Click the arrow to the right of the Physical I/O title to display data for the total physical activity, or only for physical reads or writes.
The Datafiles I/O Summary table displays all of the I/O activity details of all datafiles on the cluster. Clicking the datafile’s name displays the Physical I/O Activity page, which presents the datafile’s physical read and writes, plotted over the time range, along with the overall physical reads and writes.