Chat now with support
Chat with Support

Spotlight on Oracle 11.0 - 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

SQL Time Breakdown Page

The SQL Time Breakdown page displays extra information about the SQL statement selected in the Top SQL table.

To open the SQL Time Breakdown page

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

  2. Click I/O | SQL Page.

  3. Select a SQL Statement in the Top SQL grid.
  4. Click SQL Time Breakdown.

Note: Click Full screen for an expanded view of SQL Details. SQL Details (Full Screen) Page

SQL Time Breakdown (Grid)

SQL Time Breakdown displays statistical information about the selected SQL statement, including execution statistics and a breakdown of the time spent processing the statement. SQL statistics may be used to identify where the SQL statement can be tuned to use system resources more efficiently.

Column Description

Category

Each row in the table investigates a specified statistical category.

Value

The value of the statistic the last time the Top SQL page was refreshed.

Per Exec

In execution statistics, the value of the statistic per execution of the SQL statement.

Per Row

In execution statistics, the value of the statistic per row retrieved.

Pct Elapsed

Within the total elapsed time, the percentage of time spent in each stage of processing.

Big Category  

Time Breakdown (ms) - Chart

Time Breakdown (ms) displays the elapsed time spent in each stage of processing, and may show where the SQL statement can be tuned for greater efficiency. The stages displayed include:

  • Application
  • Cluster
  • Concurrency
  • CPU
  • I/O
  • Java
  • PL/SQL
  • Other

If the amount of time spent in Java or PL/SQL processing is significant, examine the application that is responsible for originating the Java or PL/SQL processing.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating