Chat now with support
Chat with Support

Foglight for Oracle (Cartridge) 5.9.7.10 - User Guide

Installing and Configuring Agents Using Foglight for Oracle
Viewing the Databases Dashboard Assigning Instances to Users Selecting an Instance to Monitor Foglight for Oracle Overview Dashboard Overview view Advisories view SQL Performance Investigator (SQL PI) Oracle Activity Drilldown Pluggable Databases Drilldown Storage Drilldown Reviewing Configuration Settings Reviewing the Alert Log Reviewing Monitored Data Guard Environments Reviewing ASM Instances Reviewing Exadata-related Information
Administering Foglight for Oracle Reporting Reference Glossary

Home Page Toolbar

The Foglight for Oracle Overview dashboard provides the following toolbar buttons.

Table 5. Foglight for Oracle Home Page Toolbar

Opens the Overview view.

Opens the Advisories view.

Opens the SQL Performance Investigator (SQL PI) drilldown, which displays performance-related data at the following levels:

Opens the Reviewing Instance Usability, which contains the following panels:

Oracle pluggable database only — Opens the Pluggable Databases Drilldown, which contains the following components:

Opens the Storage Drilldown, which contains the following panels:

The Storage panels are common for both RAC and all of the instances.

Opens the Configuration drilldown, which contains the panels listed below.

Opens the Alerts drilldown, which contains the following panels:

In RACs that have Exadata configured, opens the Exadata drilldown, which contains the following panels:

Overview view

The upper section of the view includes general information on the monitored instance:

Each tile is constructed of a title that state the name of the monitored issue and an aggregation of the alarms relevant to that issue.

The tiles are organized by priority:

The right panel is used to display either alarms or Top 10 SQLs:

Advisories view

The Advisories view is provided to continually analyze application performance to identify performance inefficiencies, to guide you through problem resolution strategies, and to deliver a step-by-step action plan for maximizing database performance.

The upper section of the Advisories view includes general information on the monitored instance:

The lower section of the Advisories view contains the following two elements:

Refer to the table below for the Lists of advisories and short descriptions of their purpose:

Table 6. Foglight for Oracle Advisory List

Helps to indicate when a defined total memory size is not optimal and provides recommendations on how to tune it.

Helps to indicate when a defined SGA size is not optimal and provides recommendations on how to tune it.

Helps to indicate when a defined PGA size is not optimal and provides recommendations on how to tune it.

Indicates when a workload is not distributed equally across all nodes and provides more details for further investigation.

Helps to indicate that undo size should be tuned and provides some recommendations on how to do it.

Helps to indicate a high percentage of hard parsing and find potential SQL statements for using bind variables.

Indicates when the overall workload consumption exceeded the baseline. Deviations outside the baseline range suggest abnormal or unexpected activity and should be investigated to determine whether they suggest a performance problem.

Indicates when the total instance CPU usage exceeded the baseline. Deviations outside the baseline range suggest abnormal or unexpected activity and should be investigated to determine whether they suggest a performance problem.

Indicates when the total instance wait for user I/O usage exceeded the baseline. Deviations outside the baseline range suggest abnormal or unexpected activity and should be investigated to determine whether they suggest a performance problem.

Indicates when the total instance wait for network exceeded the baseline. Deviations outside the baseline range suggest abnormal or unexpected activity and should be investigated to determine whether they suggest a performance problem.

Indicates when the total instance wait for commit exceeded the baseline. Deviations outside the baseline range suggest abnormal or unexpected activity and should be investigated to determine whether they suggest a performance problem.

Indicates when the total instance wait for concurrency exceeded the baseline. Deviations outside the baseline range suggest abnormal or unexpected activity and should be investigated to determine whether they suggest a performance problem.

Application Wait Deviation

Indicates when the total instance wait for application exceeded the baseline. Deviations outside the baseline range suggest abnormal or unexpected activity and should be investigated to determine whether they suggest a performance problem.

Other Wait Deviation

Indicates when the total instance categorized as "Other" wait for application exceeded the baseline. Deviations outside the baseline range suggest abnormal or unexpected activity and should be investigated to determine whether they suggest a performance problem.

Cluster Wait Deviation

Indicates when the overall cluster wait consumption exceeded the baseline. Deviations outside the baseline range suggest abnormal or unexpected activity and should be investigated to determine whether they suggest a performance problem.

SQL Performance Investigator (SQL PI)

The SQL PI view provides the ability to investigate the activity and resource consumption of a selected instance. There are two levels of metrics available:

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating