Current Sessions Node
The Real-Time mode Current Sessions node traces real-time instance and session activity sorted in accordance with chosen Resource and Toolbar settings. The Time range selector is unavailable, as all displays are fixed on real-time presentation.
Current Instance Activity
The = 4) BSPSPopupOnMouseOver(event)" CLASS=BSSCPopup id=A1>Activity Timeline dynamic representation displays the instance resource consumption in a layered manner, and the Resource Breakdown in pie-chart fashion, both, as of the last minute.
Activity Summary Panes
The following two panes are displayed/hidden by clicking
on the 
/
icon.
The Oracle Sessions Summary pane displays a current reading of the number of existing Oracle sessions, and their grouping as to whether active or idle. Active sessions are further classified as to their current wait state usage. These readings indicate how your Oracle sessions are employing system resources.
The System Resource Usage pane displays the CPU and Memory resources as follows:
CPU - Total percentage of CPU being used, divided into the portion used by this Oracle instance and the portion used by all other activities.
Memory - Server computer RAM, divided into the amount used by this Oracle instance, the amount used by all other activities and the remaining idle capacity.
Current Session Pane Listing
The list pane displays a current snapshot of all presently live sessions sorted in accordance with the = 4) BSPSPopupOnMouseOver(event)" CLASS=BSSCPopup id=A2>resource selection.
Select individual
current sessions (
) for further analysis and display
by double-clicking the session of interest. The selected session then
joins the left node listing, where it remains until up-to-an-hour after
the session expires (that is, becomes inactive) or the user disconnects
from Performance Analysis.
Use this feature to easily identify the most resource-demanding sessions currently affecting your system.
Right clicking within this area displays the following pop-up menu:
|
Pop-up Menu |
Description |
|
View SQL |
Display the statement syntax in [Quest] SQL View. |
|
Tune SQL... |
Opens SQL Tuning and commences analysis of the chosen SQL statement. |
|
Copy SQL to Clipboard |
Make the SQL text available for pasting into a Windows application. |
|
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 '...' |
|
Kill Session |
Launches TOAD to terminate the Oracle session. |
|
Show Background Sessions |
Determines whether or not to display the Oracle background sessions. |