Chat now with support
Chat with Support

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

* 
IMPORTANT: Only messages that are explicitly defined in the Ignore List will not be displayed. Messages that were not added to either the Match or Ignore lists appear with the name Other, the type of Oracle alert messages, and the severity Information. Therefore, ensure that messages that do not need to be displayed are added to the Ignore List.

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

•
Alert Log Messages Chart
•
Alert Log Messages Table
Alert Log Messages Chart

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.

•
Informational — displayed on the screen, but does not invoke alarms
•
Warning
•
Critical
•
Fatal

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.

Alert Log Messages Table

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

•
Timestamp — the exact time and date when the alert log message was created
•
Severity — can have one of the values listed below
•
Informational
•
Warning
•
Critical
•
Fatal
•
Message — the title of the Oracle error message
•
Dump File — this field is populated by a link only if the error message also refers to a dump file. When the link is clicked, the Dump File popup appears, displaying the first 100 lines of the dump file contents.
•
Name — the alert log name
•
Type — the alert log type, such as Oracle errors or Oracle alert messages
* 
NOTE: Both Name and Type refer to the parameters defined using the Alert Log view in the Databases Administration dashboard.

Reviewing Monitored Data Guard Environments

Starting in version 5.7.5.50, Foglight for Oracle provides a detailed dashboard for monitoring Data Guard environments. The Data Guard environment information is presented only after Data Guard environments are configured. The Data Guard tab lists all Data Guard environments which have been configured.

To access the detailed dashboard for that Data Guard environment, click the name of that Data Guard environment under the Name column.

Figure 2. Accessing the Data Guard Dashboard

The Data Guard dashboard displays a Data Guard status, provides information about Primary and Standby databases, monitors progress and performance of log transfer and apply processes.

The Data Guard dashboard has three tabs:

•
Summary — For details, see Reviewing Summary Information
•
Performance — For details, see Reviewing Performance Information .
•
Log Shipping Status — For details, see Reviewing Log Shipping Status Information .

Reviewing Summary Information

The Summary tab displays information about all Primary and Standby databases that are configured for the Data Guard environment. It comprises the following sections:

•
General information about Data Guard environment — shows details about a Data Guard environment that includes its protection mode, fast-start failover status and if Data Guard Broker is enabled.
•
Primary Database table — shows details about Primary database that includes database mode, switchover status, and DG errors that were raised in the Primary database during the selected time frame.
•
Standby Databases table — shows a list of Standby databases and their details, which include statuses, DG errors that were raised in the Standby database, and a number of received and applied log gaps.
•
Gap Time Chart — provides a representation of the current received and applied gap time in seconds for each Standby database.
* 
IMPORTANT: Gap Time Chart is available for Standby databases that are monitored by users that have SYSDBA privileges.

Reviewing Performance Information

The Performance tab displays the following charts:

•
Primary Redo Generation Rate chart — provides a redo generation rate of the Primary database per hour.
•
Transport Rate bar chart — provides a transport rate for each Standby database per hour.
This chart can be displayed in two modes. You can switch the mode in the menu of Data Guard dashboard.
a
Displaying all monitored Standby databases of the specific Data Guard environment in the same chart.
b
Displaying only one selected Standby database in the chart.
•
Standby Apply Rate bar chart — provides an apply rate for each Standby database per hour.
This chart can be displayed in two modes. You can switch the mode in the menu of Data Guard dashboard.
a
Displaying all monitored Standby databases of the specific Data Guard environment in the same chart.
b
Displaying only one selected Standby database in the chart.
•
Estimated Failover chart — provides an estimated failover time in seconds for each Standby database.
* 
IMPORTANT: Estimated Failover chart is available for Standby databases that are monitored by users that have SYSDBA privileges.
This chart can be displayed in two modes. You can switch the mode in the menu of Data Guard dashboard.
a
Displaying all monitored Standby databases of the specific Data Guard environment in the same chart.
b
Displaying only one selected Standby database in the chart.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating