Chat now with support
Chat with Support

Spotlight on Oracle 10.10 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Troubleshooting: Connection Problems

Session Details Page

The Session Details page shows summary information for a session.

To open the Session Details page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.

  2. Click Top Sessions Page.

  3. Select the session to view in detail.
  4. Click Session Details.

Note: Alternatively, you can view session details by I/O Time on the IOSession Details Page.

Data on the Session Details page

Data Description
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.
Waiting for

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.

Action

Description

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

Chart Description
Resource Waits The breakdown of total resource wait categories.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating