Chat now with support
Chat with Support

Spotlight on Oracle 10.5 - Release Notes

Plan Page

The Plan table displays information about all execution plans found for the selected SQL statement. The information covers all plans and all the steps with each plan.

To open the Plan 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.
  4. 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
  5. Click SQL Statements Page and select a SQL statement.
  6. Click SQL Statement Details Page | Plan.

Plan Grid

You can view the grid as a tree or flat table. Tree View

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

Column Description


Each row in the table represents an execution plan or plan step found for the SQL statement displayed in SQL Text above.

Act Rows

The number of rows returned by a plan step that are either used by the next step in the plan, OR that are returned to the user or application that submitted the SQL statement for processing.

Logical Reads

The total number of logical reads performed for the specified plan or plan step.

Physical Reads

The total number of physical reads performed for the plan or plan step.

Time (ms)

The total elapsed time spent executing the plan or plan step. The time taken includes the time taken to execute any child steps.

Exec Count

The number of times the plan or plan step was executed.


A unique identifier for the current step.


The ID of the step that is the parent of the current step. The output of the current step is fed into its parent step for processing.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating