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:
This panel supports the following tasks:
• |
• |
• |
• |
The Instance pane contains the following indicators:
To investigate a single instance, select the requested instance from the list at the top of the panel. The display switches to instance usability. For details, see Reviewing Instance Usability .
The Activity Locks panel for a RAC comprises the following panes:
The Locks Activity pane displays a breakdown of all lock types and their general properties.
The Lock Tree (Current) pane displays current data, which is available only in real-time mode.
Clicking any locking or locked session table row displays a popup that is used for viewing further details. For information see Session Details Popup .
The name of the program that is processing the SQL statements | |
The SQL text of the SQL statement that is currently being processed in this session |
This pane comprises the following sections:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center