Chat now with support
Chat with Support

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

Using the Currently Selected Database Group Table

The currently selected database group table displays the following columns.

Sev

The highest severity alarm of the Oracle database (whether a database instance, RAC or RAC node), which determines the database’s health state.

Name

The name of the Oracle instance, RAC or RAC node. In addition, this row includes the Go to Home Page button.

Version

The version number of the Oracle database instance.

Up Since

The date and time that the Oracle database instance (or, in a RAC, the instance that was the earliest to restart) was last restarted.

Workload

The workload (average active sessions) for the Oracle database instance or RAC. When holding the cursor over the workload graph, the dwell displays a chart that shows the workload history over the specified time range.

DB Alarms

The number of warning, critical, and fatal alarms for the Oracle database instance/RAC.

When holding the cursor over one of the alarm counts, the dwell displays the most recent alarms invoked for this database, sorted by severity.

Clicking this field displays the Alarms list, which is listed by severity order. See the Foglight Online Help, Monitoring System-Wide Alarms for details on the alarm information.

Host

The name of the computer that is hosting the database instance or RAC.

CPU Load (%)

The overall operating system CPU usage by all processes (including CPU usage by the database).

Memory (%)

The percentage, within the total memory, of memory consumed by all operating system processes (including the database). This value includes both RAM resident memory and swapped memory.

Disk (% Busy)

The percentage of time the busiest device spent serving system-wide input/output requests. This metric serves as a measure for the system I/O load.

Agent

The operational status of the monitoring agent.

When the agent instance is running, the State icon () is green, and holding the cursor over the icon displays the message Collecting Data.

When the agent instance is running but not collecting data, holding the cursor over the icon displays one of the following status messages listed below.

When SQL PI is configured the SQL PI icon is displayed.

OS

The status of the OS data retrieval.

NOTE: While the Foglight for Oracle agent retrieves OS data, several OS metrics cannot be retrieved without the Infrastructure cartridge agent. IF OS monitoring was disabled during the creation of the Foglight for Oracle agent through the Oracle Monitoring Installer wizard, the wizard cannot automatically create the Infrastructure cartridge agent; However, this agent can be created manually using the Dashboards > Hosts > Hosts dashboard. For details, see Adding a Monitored Host in the Foglight for Infrastructure User and Reference Guide.
NOTE: If the Infrastructure agent was created, but OS database is collected only by the Foglight for Oracle agent, click the OS status to OS data collection through the Infrastructure agent.

Viewing Data about the Exadata Cells

The table displayed in the Exadata tab contains the following columns.

Table 4. Exadata table

Sev

The highest severity alarm invoked within all cells monitored by the selected agent, which determines the agent’s health state.

Name

The name of the Exadata agent.

Version

The version number of the Oracle Linux used for running the Exadata storage server.

Online Cells

The number of cells monitored by the selected agent that are currently online.

Temperature Status

The temperature status of all cells monitored by the selected agent, as provided by the Baseboard Management Controller (BMC); indicates whether the temperature is normal. Any deviation from the normal temperature value, which is determined by Oracle, invokes an alarm indicated using an orange color on this column.

Total Read Rate (Mb/S)

The rate (megabytes/second) at which data was read from all celldisks during the specified time range.

Total Written Rate (Mb/S)

The rate (megabytes/second) at which data was written on all celldisks during the specified time range.

Alarms

The number of warning, critical, and fatal alarms for the celldisks.

When holding the cursor over one of the alarm counts, the dwell displays the most recent alarms invoked for these celldisks, sorted by severity.

Clicking this field displays the Alarms list, which is listed by severity order. See the Foglight Online Help, “Monitoring System-Wide Alarms” topic for details on the alarm information.

CPU Load (%)

The overall operating system CPU usage by all processes (including CPU usage by the database).

Memory (%)

The percentage, within the total memory, of memory consumed by all operating system processes (including the database). This value includes both RAM resident memory and swapped memory.

Indicator whether data is being collected.

Foglight for Oracle Overview Dashboard

Foglight for Oracle Overview Dashboard

The Foglight for Oracle Overview dashboard provides various detailed views that are accessible using the toolbar.

The Overview dashboard contents depends on whether a RAC (Real Application Cluster) or an Oracle database instance is selected.

Breakdown and Baseline Chart Formats

Several charts can display information in either of the following formats:

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating