Chat now with support
Chat with Support

Foglight for Oracle (Cartridge) 5.9.4.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

Home Page Toolbar

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

 
Table 5. Foglight for Oracle Home Page Toolbar
Name
Description
Overview

Opens the Overview view.

Advisories

Opens the Advisories view.

SQL PI

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

•
High-level data — available for all instances.
•
In-depth data, delivered by means of the Cluster view or Instance view tree — available only for instances or RACs that have Performance Analysis installed and configured.
Activity

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

•
Real-Time — see Viewing the Foglight for Oracle Real-time Summary Page .
•
Usability — see Reviewing Instance Usability and Reviewing Cluster Usability .
•
Locks — see Reviewing Locks Activity at the Cluster Level and Reviewing Locks Activity at the Instance Level .
•
Sessions — see Viewing Detailed Sessions Data .
•
Overall Datafiles I/O — see Viewing Datafiles I/O Activity at the Cluster Level and Viewing Datafiles I/O Activity at the Instance Level .
•
User-defined Collections — see Viewing User-Defined Collections .
Pluggable Databases

Oracle instance 12C - pluggable only — Opens the Pluggable Databases Drilldown, which contains the following components:

•
Pluggable Databases List table — see Pluggable Databases List table .
•
Overview tab — see Overview tab .
•
Activity within Instance — shows the selected pluggable databases’ activity as part of the entire instance activity. For details, see Activity within Instance/Cluster tab .
Storage

Opens the Storage Drilldown, which contains the following panels:

•
Tablespaces and Datafiles — see Tablespaces and Datafiles Panel .
•
Redo Logs — see Redo Logs Panel .
•
Archive Logs — see Archive Logs Panel .
•
Invalid Objects — see Invalid Objects Panel .
•
Database Backup — see Database Backup Panel .

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

Configuration

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

•
SGA — see Reviewing SGA Settings at the RAC Level .
•
Initialization Parameters — see Reviewing the Initialization Parameters .
Alert Log

Opens the Alerts drilldown, which contains the following panels:

•
Error Log — see Reviewing the Alert Log .
•
Alert log — see Reviewing the Alert Log .
Exadata

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

•
Summary
•
Performance
•
InfiniBand Topology

Overview view

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

•
Oracle server version
•
Host. For clustered host, the active host is displayed.
•
OS Version
•
Configuration
•
Archive Mode

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:

•
Availability — Shows information and alarms about the availability of the instance. Also includes the monitoring state for that instance.
•
HA/DR — High Availability (HA) and Disaster Recovery (DR) state of the instance. Displays the state of the resources used for availability. For example, Always On, Cluster, Replication, Mirroring, Log Shipping.
•
Storage — Shows the space utilization level for all Data and Log file groups.
•
Infrastructure — Provides general information collected from the server:
•
CPU — Oracle CPU utilization compared to the general host CPU utilization.
•
Memory — Amount of memory Oracle uses compared to other processes and the total memory on the server.
•
Busiest Disk — Utilization of the busiest disk on the monitored server.
•
Operational — Displays the following information:
•
Alarms on failed jobs.
•
Alarms on invalid objects.
•
Alarms on the alert log.
•
Performance — Summarizes general information collected from the SQL PI dashboard. The pie chart displays the average workload divided by resources over time. The graphs display the total workload trend over time.
The Instance Performance tile also displays the following issues:
•
Throughput issues (for example, execution, logons, and transactions per second)
•
Current sessions state (for example, Active, Inactive, and Blocked)

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

•
Alarms
 
* 
NOTE: Only the three resources would directly be displayed, according to the importance. The state of backup’s alarms is also displayed.
•
Display all active alarms for the underlined instance.
•
Enable sorting by creation time or severity.
•
Top 10 SQLs — Displays the 10 SQLs with the longest duration.

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:

•
Oracle server version
•
Host. For clustered host, the active host is displayed.
•
OS Version
•
Configuration
•
Archive Mode

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

•
Action Plan: Summarizes available advisories that present opportunities to increase the overall performance of your database.
•
Advisories: Lists advisories, action types, and the relevant descriptions. Click each advisory to view detailed analysis results, a complete description of the recommended action to be taken, and the background information of this tuning area.
* 
TIP: Advisories are listed in the order of their priority that considers the severity of the detected deviation and the type of advisory.

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

Table 6. Foglight for Oracle Advisory List
Advisory Name
Description
Instance Total Memory

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

SGA Size

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

PGA Size

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

Unbalanced Cluster Workload Distribution

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

Undo Size

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

Bind Variables Candidates

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

Oracle Workload Deviation

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.

CPU Usage Deviation

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.

User I/O Usage Deviation

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.

Network Wait Deviation

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.

Commit Wait Deviation

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.

Concurrency Wait Deviation

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:

•
Without SQL PI configured — basic History, lock analysis data, and activity highlights.
•
With SQL PI configured — The ability to perform a more in-depth analysis and investigation of the Instance activity and resource consumption by adding a dimension view of the activity, change tracking analysis, execution plan analysis and compare toll.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating