Top Sessions Tab
The Top Sessions tab is a pane display that lists the top resource consuming sessions per time range. Both resource and time range can be specified. The sessions are sorted in a descending resource consuming order (according to the specified Resource). Because the display includes all activity up to one hour ago, sessions that were active in this period but are no longer connected (dead), are also displayed.
The resources displayed include an initial general set and an additional listing of metrics specific to the chosen Resource. The following table contains a description of the general columns displayed in the Top Sessions grid.
|
Column |
Description |
|
SID |
Session identifier for the session. |
|
Serial |
Serial number of the session. SIDs can be reused after the session disconnects, but the combination of SID and Serial number is always unique. |
|
SQL Executions Started |
Number of SQL statement executions that ended during the current interval. |
|
Logon Time |
The date and time that the user logged on to the database. |
|
DB User |
Oracle user used by the program to connect to the Oracle instance. |
|
SQL Executions Ended |
Number of SQL statement executions that ended during the current interval. |
|
Status |
Denotes if the session is active or inactive for sessions that are currently connected or dead for sessions that logged out during the specified time frame and are no longer connected. |
|
Logout Time |
The date and time when the session was logged out. |
Double-click a session entry to drilldown into the session and trace its activity.
In addition to the Common Elements in the Performance Analysis Console, right-clicking the list pane display area in the Top Sessions tab displays a pop-up menu with the following options:
|
Option |
Description |
|
View SQL |
Display the active statement syntax in [Quest] SQL View. |
|
Tune SQL...
|
Opens SQL Tuning and commences analysis of the chosen SQL statement. |
|
Copy SQL to Clipboard |
Copies the SQL Text for pasting into a Windows application for further analysis. |
|
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. |