Chat now with support
Chat with Support

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

Reviewing SGA Settings at the Instance Level

Use the SGA management section to review the current SGA settings for the entire RAC, by means of a row that contains the following indicators:

The SGA Utilization section contains a chart that displays the instance’s current SGA size in either of the following views:

Use the SGA Size section to review the breakdown of the SGA within the instance, by means of the following components:

The Free Space section displays, both graphically using a chart and in a table format, the free space reserved for the following types of SGA pools for each of the RAC’s nodes:

Reviewing the Initialization Parameters

The Initialization Parameters panel displays the entire list of initialization parameters, as defined by Oracle. These parameters define the characteristics of each Oracle instance when the instance is started.

Upon clicking anywhere on a row that displays a specific initialization parameter, a popup appears, listing the properties of the selected parameter:

Change History table — displays the entire history (time and dates) when the Foglight for Oracle agent detected the changes made to this parameter since the instance was created.

The Initialization Parameters table varies between instance mode and RAC mode. For details about the RAC mode view, see Reviewing the Initialization Parameters in RAC Mode .

In Instance mode, the table displays the following columns


Parameter name.


In multitenant architectures, the name of the pluggable database.

PDB is Modifiable

Hidden by default. In multitenant architectures, displays the list of pluggable databases that have been modified.

Current Value

The parameter’s current value.


Indicates whether the parameter’s current value is its default value, as defined by Oracle.


Indicates whether the initialization parameter is dynamic, that is, can be modified using the ALTER SESSION, ALTER SYSTEM, or ALTER SYSTEM DEFERRED commands while an instance is running.


Indicates whether the parameter’s value has been modified.


Indicates whether the parameter is deprecated, in which case specifying it in a parameter file will invoke a warning message when the instance starts.


The parameter type, as defined by Oracle.


The parameter description, taken from Oracle site.


Indicates whether the pluggable database can be modified.

In RAC mode, the Initialization Parameters panel can be accessed by selecting either the Whole Cluster or a specific instance view.

In the Whole Cluster view, instance-specific initialization parameters are displayed with the icon to the left of the parameter name, and the names of the various instances are displayed in the Scope column.

The following columns in Initialization Parameters table differ in RAC mode.


Parameter name. A icon to the left of the name indicates that the parameter applies differently to specific instances.


Indicates whether the parameter applies to the entire RAC or varies between specific instances.

Current Value

The parameter’s current value. This value can be either instance-specific or apply to the entire RAC.

Reviewing the Alert Log

The Alerts drilldown provides a view on the alert and error logs received for a selected Oracle agent during the specified time range.

This drilldown comprises the following panel:

Reviewing the Alert Log

By default, the Alert Log panel displays all of the alert log messages.

To display messages under a pre-defined name, category and severity, create or edit patterns for these messages in the Match List, which is found in the Alert Log view in the Databases Administration dashboard, and add the corresponding regular expressions to this list. To prevent messages from being displayed on the Alert Log panel, add these messages to the Ignore List.

The Alert Log panel comprises the panes described in the following topics:

The Alert Log Messages chart provides a graphic, color-coded representation of the various alert log messages, broken down by their severity level, as described below.

The severity assigned for each alert, as well as the minimal severity level (Warning or higher) for which alarms are to be invoked as a result of the alert, are defined using the Alert Log view in the Databases Administration dashboard, accessible from the Agent Settings button.

The Alert Log Messages table provides the following details about each alert log:

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating