Chat now with support
Chat with Support

Foglight for Oracle (Cartridge) 5.7.5.50 - 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 instance 12C - pluggable 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 maxmizing 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:

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:

The performance tree provides iterative (up to three levels) access to any of the key dimensions associated with Oracle database activity, based on the OLAP multidimensional model and an instance view of the instance activity. Domain nodes offer a hierarchical view of all types of Oracle activity characteristics.

Selecting a dimension from the tree determines what subset of activity is displayed. Iterative drill-down into domains of interest provides increasingly refined focus and diagnosis.

5
Select Machines under the selected SQL Statement, to view the computers on which the statement was run.

In a similar manner, such iterative drilldowns can be carried out into any Oracle dimension of interest, to gain a complete understanding of the causes of its behavior.

The default Oracle dimensions are as follows:

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating