Chat now with support
Chat mit Support

Spotlight on Oracle 10.5 - Release Notes

SQL Statements Page

SQL Statements Page

The SQL Statements page lists all the SQL statements within the trace file selected in the Trace Files Page.

To open the SQL Statements page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.
  2. Click SQL & Application Workload | Analyze Trace | Trace Files.

  3. Select a Trace File.

    If the trace file has not been analyzed yet, right-click its row in the Trace File Details table and select Analyze Trace File. Analyze Trace Settings Dialog

    Click SQL Statements

SQL Statements Grid

Click a row to open SQL Statement Information.

Double-click the row to open the SQL Statement Details Page for the statement.

Note: Not all columns are visible by default. Use the Column Organizer to view hidden columns. Show, Hide & Order Columns

Column Description

SQL ID

The number allocated to the specified SQL statement within the trace file.

Elapsed (ms)

The total server execution time for the SQL statement (parse, execute and fetch).

CPU (ms)

The CPU time spent executing the SQL statement.

Fetch Count

The number of fetches performed for the SQL statement.

Parse Count

The number of parses performed for the SQL statement.

Logical IO

The number of logical I/O operations for the SQL statement.

Total Rows

The total number of rows processed for the SQL statement.

Disk IO

The number of disk I/O operations for the SQL statement.

Execute Count

The number of times the SQL statement was executed.

% Total Elapsed

The percentage of the total elapsed time spent executing the SQL statement.

Logical IO/Exec

The average number of logical I/O operations performed each time the SQL statement was executed.

Logical IO/Row

The average number of logical I/O operations performed for each row processed by the SQL statement.

CPU/Exec

The average number of CPU operations performed each time the SQL statement was executed.

Disk/Exec

The average number of disk I/O operations performed each time the SQL statement was executed.

SQL Statement

The text of the SQL statement.

Address

The address where data has been returned by the SQL statement.

Formatted SQL

The text of the SQL statement formatted for readability.

Hash Value

The hash value for the SQL statement in the library cache.

SQL Statement Information

SQL Statement Information shows the following information about the selected SQL statement. More information on the selected SQL statement is available from the SQL Statement Details Page.

Section

Description

SQL Text The full text of the selected SQL statement.
SQL Statistics

The SQL Statistics table displays statistical information about the selected SQL statement.

  • Name - The name of a SQL statistic for the selected statement.
  • Value - The value of the statistic within the chosen trace file.

 

Related Topics

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen