The Session Details page shows summary information for a session.
To open the Session Details page
Select the Spotlight on Oracle connection in the Spotlight Browser.
Click Top Sessions Page.
Note: Alternatively, you can view session details by I/O Time on the IO | Session Details Page.
Data on the Session Details page
|Oracle SID||The session identifier.|
|User name||The Oracle account name of the session.|
|Server||The Oracle server program that supports this session. This may be a dedicated server, shared server, or dispatcher.|
|Status||The current status of the session. This can be ACTIVE or INACTIVE.|
|Container Name||(Oracle 12c) The name of the container database.|
|Block gets||The total number of current (update) mode reads since the session was established.|
|Consistent gets||The total number of consistent (query) mode reads since the session was established.|
|Block changes||The total number of block changes the session has performed.|
|Program||The client program that initiated the session.|
|Wait state/time||The status of the wait, and how long it has waited.|
The details of any resource wait. Deal With Wait Events
If the wait is for a file IO operation (such as db file sequential read or db file scattered read), Spotlight displays the name of the table or index to which the IO is occurring. If you selected fast initialization when you connected to the database (Oracle Initialization), the name of the table or index is not shown.
|Serial||The serial number for the session. Although the Oracle SID may be reissued as sessions connect and disconnect, the combination of SID and serial number remains unique.|
|OS user||The operating system user that established the session.|
|Client PID||The operating system process identifier for the client process that created the session.|
|Server PID||The process identifier of the Oracle server process that supports this session.|
|Phys reads||The number of physical reads initiated by the session.|
|CPU utilization (ms)||The amount of CPU time consumed by the server process, in milliseconds.|
|Hit ratio||The percentage of block get requests that were satisfied by blocks cached in the buffer cache.|
SQL on the Session Details Page
Actions you can take on the SQL statement in the Most Recent SQL grid.
|Click Explain SQL||
Explain the SQL via the Explain Plan. Tools | Explain Plan
|Click SQL Optimizer||
Display context-sensitive tuning advice for SQL statements via SQL Optimizer (or SQL Tuning). Tools | SQL Optimizer
Note: For more information on SQL Optimizer, see the SQL Optimizer documentation.
|Click Show in Top SQL||
Open the SQL in the TOP SQL Drilldown | Top SQL Page
|Right-click the SQL Text window and select Format SQL.||Display the SQL statement in a more readable form.|
Note: In many versions of Oracle, it is not possible to obtain more than 1000 bytes of this SQL text efficiently.
Chart on the Session Details Page
|Resource Waits||The breakdown of total resource wait categories.|