Individual Session Nodes
This feature's purpose is to trace the activity of a currently running session and its resource consumption up to the last hour. In this window, the Time Selector again becomes active. The Individual Session window is divided into three panes.
Session Activity Timeline
The upper-third graphically display an Activity Timeline and Resource Breakdown pie chart for the chosen session.
Session Detail Panes
The following two panes are displayed/hidden by clicking
on the 
/
icon.
The Oracle Session Details pane displays the Oracle session properties on a dynamic basis.
The "Waiting For" parameter is the actual wait event on which the session is presently waiting.
The System Process Details pane displays operating system attributes of the session's server process.
In a MTS environment, the Server PID attribute dynamically changes to reflect the operating system Process ID of the shared server that is currently serving the session.
Session Analysis Tools
The lower-third session tabs display facilitates focusing on specific session parameters:
Session Overview tab - Total Oracle resource usage and breakdown for the session in the activity timeline period with pane-listed metrics, corresponding to the selected time frame.
Session Statistics tab- Displays basic Oracle or extended statistics in a classical manner for the session, organized by Oracle groupings. The displayed Value is a function of the totaling method in effect.
The first drop-down listing allows for a choice of either:
Oracle Detailed Statistics: standard V$SESSTAT statistics, grouped by class.
Oracle Extended Statistics: calculated expert statistics.
The second drop-down listing totals either for:
Selected Time Range: The metric display reflects only the currently displayed time range activity.
Since (session) Logon: Reflects the entire session activity from its logon time, regardless of the selected time range.
Open Cursors tab- Addresses the question of "What are the statements currently executing by the session?" Listing and details of all cursors currently opened by the session. The selection changes to reflect the currently active cursor. The displayed statement statistics reflect the chosen resource. All displayed statistics are cumulative since the beginning of the statement execution, regardless of the selected time frame.
Right-click within the Open Cursor display area to reveal the following pop-up menu:
|
Pop-up Menu |
Description |
|
Pin Cursor |
If set, causes the active cursor to remain selected even when not active. Used for tracing a specific cursor. |
|
Multi-line SQL Text |
Expands the SQL display to a multi-line presentation so that the entire SQL is visible. |
|
Summarize SQL Text |
Shortens the SQL statements by replacing long SELECT and FROM clauses with '...' |
|
Tune SQL... |
Opens SQL Tuning and commences analysis of the chosen SQL statement. |
Use the = 4) BSPSPopupOnMouseOver(event)" CLASS=BSSCPopup id=A1>Statement Level Tabs for additional cursor analysis by clicking the cursor of interest.
Traced SQL tab- Addresses the question "What were the most recent statements executed by this session?" The display offers a trace of all the recently executed statements. Similar display to that of the Open Cursors, but includes statements that have also already completed. Each statement refers to a specific execution
Use the = 4) BSPSPopupOnMouseOver(event)" CLASS=BSSCPopup id=A2>Statement Level Tabs for additional statement analysis.
SQL Summary tab- Addresses the question "What is the impact of a specific SQL on real-time session activity?" Statements with identical SQL text are aggregated into a single entry. Similar to Open Cursors. The SQL Executions value indicates the number of distinct executions of the specified syntax as reflected in each summary line. This feature is useful when a session is rapidly executing SQLs (usually within a loop) with different bind variables and you are interested in the entire impact of the SQL rather than a single execution.
Use the = 4) BSPSPopupOnMouseOver(event)" CLASS=BSSCPopup id=A3>Statement Level Tabs for analyzing the SQL activity (the analysis tool will refer to the entire SQL grouping).
Session Locks tab- Listing of the locks (and their corresponding sessions) that are blocking (
or when expanded) or blocked
by (
or without icon) this session during the course of
its statement executions. An active lock that is currently blocking the
session is indicated with an () icon.
|
Column |
Description |
|
SID |
SID of the blocking/ed session. Click the SID to drilldown into the blocking/ed session and trace its activity. In the case of an active lock, the actual blocking/ed statement can be discovered by looking at the current active cursor in the Open Cursors tab |
|
Serial |
Serial number identifying the blocking/ed 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/ed 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 session 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.