Chat now with support
Chat with Support

Foglight for Oracle (Cartridge) 5.7.5.41 - 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) Reviewing Overall Activity Reviewing RAC Historic Activity Oracle Activity Drilldown Pluggable Databases Drilldown Storage Drilldown Reviewing Configuration Settings Reviewing the Alert and Error Logs Reviewing ASM Instances Reviewing Exadata-related Information
Administering Foglight for Oracle Reporting Reference Glossary

Filtering the Display by Severity

The Status Indicators section can be used for filtering the Databases Group table to display only instances that meet a criterion set in this section.

To filter the display by severity:
1
Click a a certain type of severity within a a specific database type (for example: Oracle instances whose severity level is Critical).
The selected filter is shown in the table’s title.
2
To select another filter, click the required status indicator (for example: Oracle > Normal severity). To display the entire list of databases, click Clear filters.

Creating User-defined Database Groups

Creating User-defined Database Groups

Use the Databases area of the navigation pane to create, edit, and remove groups of database instances. Click Edit Group to add or remove database instances from the sub-group.

To create a database group:
1
Select the parent database instance group, Database Group, under Databases in the navigation pane.
2
Click the button.
The Add Group dialog box opens.
3
Type a name for the group in the Name field.
4
Type a description for the group (optional).
5
Select an instance in the Available column, and click [>] to move the instance to the Selected column.
Alternatively, click [>>] to move all of the databases to the Selected column.
6
Click OK.
The group name appears in the Database Groups list.
The database instances are listed in the Databases pane.

After adding one or more user-defined groups, it is possible to add sub-groups to these groups.

To add sub-groups to a selected group:
1
Position the cursor on the requested group’s name.
2
Repeat Step 2 to Step 6.
* 
NOTE: The Add Group dialog box displays the name of the parent group in the Parent field. Before proceeding, ensure that the sub-group is added to the requested group.
To remove a database group:
1
Select the group to be removed.
2
Click the button.
The Remove Groups dialog box appears, asking approval to remove the selected group with all its sub groups.
 
3
Click Remove.
The group is removed from the Database Groups list.
To edit a database sub-group:
1
Select the requested group.
2
Click the button.
The Edit Group dialog box opens.
3
To add an instance to the group, select the requested instance in the Available column and click [>] to move the selected instance to the Selected column.
4
To remove an instance from the sub-group, select the requested instance in the Selected column, and click [<].
The selected instance moves to the Available column.
5
Click OK.

Components Shared by All Foglight for Oracle Screens

Components Shared by All Foglight for Oracle Screens

The tables’ Customizer button and the In-context action buttons are common to all Foglight for Oracle screens.

The Customizer button — use this button, which is found on the upper right corner of each table, to create a custom filter for the table. The filter is created by clicking Customizer and specifying the criteria that the various values should meet in order to be displayed in the table (having a specific name, exceeding a certain size, and so on). For detailed instructions and examples, see Foglight User Guide > Working with Dashboards > Working with Tables.

Figure 1. Customizer button

In-context actions buttons — found on the upper right corner of all screens:

•
Refresh — clicking this button retrieves the data acquired using the most recent sampling.
•
Agent Settings — when using panels whose configuration is set using the Databases Administration dashboard, clicking this button opens the relevant screen in the Databases Administration dashboard (for example, clicking this button from within the Databases > Locks panel opens the Locks screen).
•
Useful links — used for carrying out further investigation using the following external sources:
•
What’s New? — provides information about new features implemented and issues resolved in the current release.
•
Release Notes — provides a link to the Foglight for Oracle Release Notes.
•
Deployment Guide — provides a link to the Foglight for Databases Deployment Guide.
•
Topology Mapping — opens the Oracle_Topology_Mapping.csv file.
•
Ask Quest Community — provides a link to the forum for Foglight products.
•
Contact Support — central knowledge base about all of Quest Software’s products.
•
About — provides information regarding the product version.
Figure 2. In-context action buttons

Using the Currently Selected Database Group Table

The currently selected database group table displays the following columns.

 
Table 3. Currently Selected Database Group Table
Name
Description
Instance

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.

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.

System Utilization

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.

Monitoring Status

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.

•
Starting
•
Stopped
•
Stopping
•
Unknown

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.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating