Chat now with support
Chat with Support

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

Defining the Connection Settings for the Monitored Oracle Instances

The Connection Details view contains a table that displays all the agents that were selected before entering the Databases Administration dashboard.

2
Click Set Credentials.
8
Click Validate to proceed to the next stage of validating the instance’s connectivity.

Validating Connectivity and Starting to Monitor the Instances

After setting the default credentials for the host, these newly created credentials can now be used by the wizard to attempt to log in to the instances.

1
Click Test connection.
At the end of this process, any connectivity issues are listed in the Status column of the instance table. When the connection is successful, the Status column displays the status message Validated, which indicates that the instance connected successfully and the specified Oracle user has the required permissions.
2
Click Validate connectivity on the status bar.
3
Click Save Changes.
4
If any option other than Agent Manager local user is selected, enter the required credentials.

Use the user-defined collections feature to add customized collections to all of the currently selected agents, thereby providing for queries not included in Foglight for Oracle.

Use the Connection Details view to enable and configure the creation of user-defined collections.

2
Click Set UDC credential.
3
Click Edit Credentials for User-defined Collections.
8
Click Set.

To add user-defined collections, go to the User-defined Collections view in the Databases Administration dashboard. For details, see Configuring User-defined Collections .

If you have Oracle instances that run on virtual hosts, monitoring such instances requires setting a dedicated connection profile, in order to connect to the requested VMware server.

Establishing such a connection is necessary in order to retrieve the Virtualization overhead data, that is, the percentage of CPU that is unavailable to this virtual machine because it is being utilized either by other virtual machines or by VMware itself. The Virtualization Overhead indicator is displayed in both the real-time and history summary pages.

2
Click Set credentials.
3
In the Edit Credentials dialog box, click Edit VMWare connection details.
6

Defining the Connection Settings for the Monitored ASM Instances

The Connection Details view contains a table, which displays all of the agents that were selected before entering the Databases Administration dashboard.

3
Click Settings.
4
Click Administration.
6
Click Set Credentials.

Defining Data Collection and Storage Options

The Foglight for Oracle agent collects and stores data at all times, even when the browser window that displays the data is not active. Use the Collections view in the Databases Administration dashboard to specify:

The available collection frequencies, which can be selected from the field The selected agent's current collection frequency is, are:

The Collections table contains the following columns.

Table 29. Collections

Defines whether the selected collections are sampled and stored.

The name of the collection. This list is sorted in alphabetical order.

Used for defining the collection interval, in seconds, in offline mode (for example: 300).

Offline frequency refers to the longest interval possible for sampling the monitored instance.

Used for defining the collection interval, in seconds, in online mode (for example: 60).

Used for defining the collection interval, in seconds, in real-time mode (for example: 20).

Only one collection can be sampled at real-time frequency at any given moment.

The amount of time, in seconds, that elapses before the query times out.

2
Click Edit.
8
Click Set to apply these settings or Cancel to reject them.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating