Oracle Cloud Infrastructure Documentation

Graphical Explain Plan

To view the Graphical Explain Plan:

  1. Open the Performance Hub page from the database details page, if not already open.

    Note

    For more information about how to navigate to the Performance Hub page, see:

  2. Click SQL Monitoring to display the SQL monitoring tab.

  3. In the SQL Monitoring tab, click an ID number in the SQL ID column to display detailed information on a specific SQL statement execution. It opens the Real-time SQL Monitoring page.

    The Real-time SQL Monitoring page displays the Plan Statistics tab by default. The plan statistics for the SQL execution is displayed in the default Tabular Execution Plan view.

  4. Click View Option and change it to Graphical Explain Plan.

The SQL explain plan is presented as a collapsible tree of nodes where each node represents an operation.

Using Graphical Explain Plan

By default, the Graphical Explain Plan displays the operation nodes horizontally, with the root node of the tree on the right-side of the screen. Sections of the tree within a node can be collapsed or expanded by clicking the minus or plus sign for the node.

  1. You can zoom in or zoom out on the Graphical Explain Plan using the mouse or the keyboard +/- keys. You can also click and drag the plan within the viewport.

    An overview section is located in the bottom-right corner of the content area. It provides a visual representation of the positioning of the viewport with respect to the overall content of the plan.

  2. Click a plus sign to expand a node and display information for the operation subtree. Click a minus sign to collapse the operation subtree beneath a node.

  3. Hover over a node to view the operation name and estimated row count. Click a node to display additional information about the operation in a message box. Click Close to close the message box.

  4. Click Rotate (to the right of the Graphical Explain menu) to rotate the entire explain plan 90 degrees counterclockwise.

    Click Rotate subsequently to move the explain plan another 90 degrees counterclockwise. In any position of the tree, click the plus or minus sign to expand or contract the subtree of an operation node.

  5. Click the Back arrow at the top-left corner of the page to go back to the SQL Monitoring tab.