Chat now with support
Chat with Support

Foglight for Oracle (Cartridge) 6.3.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 Log Shipping Status Information

The log shipping status tab contains information about non received and non applied logs into Physical Standby databases of the configured Data Guard environment. It comprises the following sections:

•
Primary Database table — shows details about a current log in the Primary database.
•
Standby Databases table — shows a list of Physical Standby databases of specific Data Guard environment and details about current received and applied logs for each Physical Standby database.
•
Log Details table — shows a list of non received and non applied logs for a chosen Physical Standby database from the Standby Databases table above.

Reviewing ASM Instances

Starting in version 5.6.5.5, Foglight for Oracle provides a detailed dashboard for monitoring ASM performance. The ASM information is presented only after ASM instances are configured.

The ASM tab lists all ASM instances which have been configured. To access the detailed dashboard for that instance, click the home button.

Figure 3. ASM tab

The ASM dashboard provides information about the ASM cluster/instance, it includes general instance information, Disk groups and disks information, ASM Parameters and ASM Alert log information.

The ASM dashboard has three tabs:

•
Summary — Reviewing Summary Information
•
Parameters — Reviewing Parameter Information
•
Alert log — Reviewing Alert Log Information

Reviewing Summary Information

The summary tab contains information about all the disk groups that are configured for the ASM, as well as the disks that are configured for each ASM disk group. This information includes the version number, status, total storage space, and the number of ASM clients.

The number of ASM clients is clickable and opens a pop-up that shows all the Oracle instances that are using a disk group managed by the ASM instance.

It also has a column named Monitored that gives an indication whether or not that Oracle instance is monitored by Foglight. If the Oracle instance is not monitored by Foglight, it is possible to monitor it immediately by clicking Monitor.

The Disk Groups table provides detailed information about each group. Selecting one or more disk groups will display additional information in the pane below, either in Map or Table View.

Each disk group in the top table or disk in the Map or Table view is clickable and opens a pop-up with additional information.

Figure 4. Dusk Groups view

For disk groups, the pop-up includes the following tabs:

•
General — General Disk group information. For example, name, state number of disks, number of fail groups, allocation unit size.
•
Storage — Disk group storage-related information
•
Performance — Performance-related information
•
I/O Operations
•
Average Service Time
•
Disk Errors
•
Operations — Currently running rebalance operations
•
Alarms — List of alarms associated with this disk group
Figure 5. Disk Group Details - Performance tab

If you select a specific disk in the Map or Table view, the pop-up includes the following tabs:

•
General — General Disk information (e.g. path, failure group, creation date)
•
Storage — Disk storage-related information
•
Performance — Disk performance-related information

Reviewing Parameter Information

The Parameters tab displays a list of all the ASM parameters and their values, as well as some other additional information for each parameter.

Figure 6. Initialization Parameters

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating