Spotlight on Oracle 10.5 - Release Notes

SQL Statement Details Page

To open the SQL Statement Details 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 and select a SQL statement.

4. Click SQL Statement Details

SQL Text

The full text of the SQL statement selected in the SQL Statements page.

SQL Statement Information

Display information relevant to the selected SQL statement.

• Overall Statistics Page
• Calls Page
• Plan Page
• Waits Page
• Binds Page
• Errors Page

Related Topics

Spotlight on Oracle Drilldowns