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
- Select the Spotlight on Oracle connection in the Spotlight Browser.
-
Click SQL & Application Workload | Analyze Trace | Trace Files.
- 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 Page and select a SQL statement.
- 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 |
|---|---|
|
Plan |
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. |
|
ID |
A unique identifier for the current step. |
|
PID |
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. |