立即与支持人员聊天
与支持团队交流

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

Using Foglight for Oracle

Using Foglight for Oracle

Foglight for Oracle monitors the Oracle database activity by connecting to and querying the Oracle database. The agents provided monitor the Oracle database system. The dashboards included with the cartridge provide a visual representation of the status of the major components of the Oracle agents. They allow you to determine any potential bottleneck in database performance.

This section provides agent configuration instructions and information on investigating Oracle database performance. It covers the entire monitoring process, starting with the discovery of the database instances and the connection with these instances, and proceeding with the use of the various drilldowns and the Global Administration options.

Viewing the Databases Dashboard

Viewing the Databases Dashboard
 
* 
NOTE: The following section describes the various components of the Databases dashboard. To learn how to customize this dashboard’s display and focus on a requested instance, see Selecting an Instance to Monitor.

The Instance home page is launched by accessing the Databases dashboard.

To access the Databases dashboard:
1
Ensure that the navigation panel on the left is open.
To open the navigation panel, click the right-facing arrow on the left.
2
On the navigation panel, click Homes > Databases.

The Databases dashboard provides an at-a-glance view of the monitored environment, with all of the currently monitored database types.

The Databases dashboard includes these sections:

•
Database cartridge type tiles — each tile represents a database type (SQL Server, SQL Server BI, Oracle, Sybase, DB2, MongoDB, Cassandra, or All Instances) and displays the number of instances for each database type, along with a breakdown according to the instance health state severity (Normal, Warning, Critical, Fatal).
When selecting the Oracle Tile the following advanced monitoring can be performed and reviewed:
•
Oracle Instances — This is the default tab, used for displaying the “regular” Oracle instances.
•
ASM — ASM-related data, which was previously retrieved through the Foglight for Oracle agent, is only enabled if the Foglight ASM instance is configured and running. For details about configuring and running this instance, see Adding ASM Instances . For details about the monitoring information displayed on the ASM tab, see Reviewing ASM Instances .
•
CRS — used for configuring the monitoring of the Clusterware software that manages the oracle RACs. For details about configuring Clusterware for monitoring, see Adding CRS Agents for Monitoring Clusterware .
•
Exadata — used for configuring the monitoring of the Exadata environment. After the Exadata agents are added, data retrieved from Exadata is displayed on this tab, as well as on the Exadata drilldown.
•
For details about configuring the Exadata environment for monitoring, see Adding Agents for Monitoring Exadata Environments .
•
For details about the monitoring information displayed on the Exadata tab, see Viewing Data about the Exadata Cells .
•
For details about the drilldown that displays data retrieved from Exadata, see Reviewing Exadata-related Information
•
Status section — includes the following components:
•
Status summary — a color-coded bar, which provides a visual representation of the summarized health condition of all instances listed in the Database Group table.
The status summary bar provides a graphic representation of the monitored environment’s current state, broken down to the number of instances and their current health state: Fatal, Critical, Warning, Normal or Unknown.
•
Database-specific health summary — when the database group All is selected, this section displays all of the currently monitored instances for each database type, divided by their health state (for example: four Oracle instances, three of which have the health state Warning and one is indicated with the health state Fatal). When a user-defined database group is selected, this section displays data only about the agents included within the selected group.
* 
NOTE: 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. For details, see Filtering the Display by Severity .
•
The Monitor button — Use this button to add instances to be monitored.
•
The Configure Alarms button — Takes you directly to the Administration > Alarms page. On the Alarms page you can configure alarm settings and specify alarm sensitivity levels. Sensitivity levels control which alarms are enabled by default.
•
The Settings button — Use this button to do one of the following:
•
Access the User Management settings, allowing you to restrict which instances specific users are allowed to view. This makes it easier to for users to find information about only the instances they are interested in. For details, see Assigning Instances to Users .
•
After selecting one or more instances of the same database type, use this button to set options for collecting, storing, and displaying data for the selected instances, as well as configuring the connection to SQL Performance Investigator (if installed). For details, see Administering Foglight for Oracle .
•
Currently selected database group table — a list of all monitored databases within the database group that is currently selected in the Databases section. For details, see Using the Currently Selected Database Group Table .
•
The Show Quick View button — provides the ability to open a quick view of the instance at the bottom of the screen.
•
The Select dashboards () button — provides direct link to several drilldowns and panels, thereby saving the need to navigate to these locations through the Overview drilldown.
 
* 
IMPORTANT: If the display is filtered to show only Oracle instances the Databases table is renamed to Oracle Instances, and a new tab titled Reporting Services is shown. For details about this tab, see the following section.

Assigning Instances to Users

The User Management screen allows you to assign specific instances to users. As a result, when users view their Database dashboard, they will only see the instances which have been assigned to them. This makes it easier to find the data which is relevant to them.

The User Management screen only displays users who are not Administrative users.

To assign instances to a specific user:
1
On the main Database dashboard, click Settings and select Users from the menu.
The User Management pane appears.
2
Click Enable User Management feature. The table will display user names of non-Administrative users only, log in information, and instance information.
3
To assign one or more instances to a specific user, locate the user’s name in the table and click Assign Instances in the right-hand column.
4
In the Assign Instances view, select the instances which should be assigned to this user and click the > button to add the selected instances to the Assigned Instances column.
5
Click Set and Close to save your choices and exit.

Selecting an Instance to Monitor

Because the Databases dashboard displays by default all of the currently monitored databases, it is advisable to customize the dashboard’s view to display only the relevant instances, and then preview such instances to decide which to monitor.

To select an instance to monitor:
1
Display only instances relevant for your needs, using one of the following methods:
•
Filter by database type — if multiple database types are being monitored, click the database type tile that represents the requested type (in this case, Oracle).
•
Filter by severity — use the status indicators to display only instances of a specific database type that share a specific health state severity. For further details, see Filtering the Display by Severity .
•
Create user-defined groups — use the Databases area to create groups that contain only the databases that need to be monitored for a specific need. For further details, see Creating User-defined Database Groups .
•
Assign Instances to specific users — When accessing a Database dashboard, non-administrative users will view only instances which have been assigned to them. For details, see Assigning Instances to Users .
2
View the selected instances’ severity level, using the status indicators.
3
Click the requested instance to view a cue card with a preview of the instance’s most significant performance indicators.
4
Click Home Page on the cue card to launch a full-screen view of the requested instance.
* 
IMPORTANT: Launching a full-screen view of the requested database by clicking the Home Page link can be carried out only for instances monitored in Foglight for Oracle mode.
相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级