The Optimizer Plan Visualization control provides an interactive and intuitive way to view your plan and statement.
|Click to show Analysis of Query for the selected plan. Click View to show the Execution Plan. Click More to show the SQL Statement.|
|Click to show the Execution Plan.|
|Click to show the operation of each session for the selected plan. Note that you can show/hide columns using Organize Columns.|
|Click to show the SQL statement for the selected plan.|
|Click to show a tabular view of all objects in use by the plan and the operations they are used in.|
Tip: While the Session Status is running there is an option to View SQL for Batch.
Note: Optimizer Plan Visualization is not available in Playback mode. Display of the SQL Statement is available in Playback mode.