There are two ways to access the Execution Plan History dialog:
• |
From History by selecting the statement or batch and by clicking Analyze in the top of the table. |
The execution plan dashboard displays the following content.
Resolving Date — Displays all the execution date and time of the selected statement.
Type — Displays the type of the execution plan.
Plan Hash Value — Displays the plan hash value of the execution plan
The execution plan is contains 3 tabs:
By clicking the Generate Plan button the execution plan is generated and can be viewed. By clicking on the Compare Plan button a pop up will appear that allows comparing all available execution plans of the selected SQL statement.
Compare can be access from the Performance tree.
The upper panes graphically displays the Workload or any other selected resource.
Use the Oracle Activity drilldown to carry out the operations described in the following topics:
• |
• |
• |
• |
• |
• |
The following image displays the main elements of the Foglight for Oracle real-time summary page. The table that follows the image identifies each element, and provides a link to display more information, corresponding to the logical dataflow within Foglight for Oracle Instance Homepage.
• |
• |
Components representing instance data flow — the main activity area in the Foglight for Oracle Instance Homepage includes several panes and flows that represent the data flow in the Oracle operation. The dataflow is represented in a top-down design, that is, from the session to the physical disk storage. |
Long queues can indicate one of the following issues:
The parameters in this pane lead to the Activity > Sessions panel. For details, see Viewing Detailed Sessions Data .
Oracle Data Guard can be configured as either physical or logical standby. For details about the preparations required for monitoring each of these setups, see Monitoring the Data Guard physical standby and Working with logical standby (SQL Apply) .
9 |
10 |
Click Verify Connectivity |
The Workload chart displays the workload of the average active sessions, plotted over time.
The workload can be plotted as either:
To display the wait events breakdown, click the arrow to the right of the Breakdown link.
The Process Activity pane displays the following parameters.
For further details, see Reviewing Instance Usability .
The actual size currently allocated to the System Global Area (SGA) memory. | ||
The actual size currently allocated to the Program Global Area (PGA) memory. | ||
This section contains the following indicators:
• |
The Disk Activity section displays the following indicators:
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center