Chat now with support
Chat with Support

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

Configuring User-defined Collections

Use the User-defined Collections view in the Databases Administration dashboard to add user-defined collections to all of the currently selected agents, in order to provide for queries not included in Foglight for Oracle.

After collections are added, this view displays all user-defined collections for all of the agents; for example, if a collection was added to 12 agents during its addition, the view will display 12 rows, showing the collection for each agent.

This view is also used for configuring the sampling frequency for each collection.

The available sampling frequencies are:

2
Click Add.
c
Click Edit credentials.
g
h
The Applying modified settings progress bar is displayed. If the modified settings are su cess fully applied, the Add a User-defined Collection dialog box opens.
3
Click Set details.
4
Enter a name in the Collection name field.
5
Enter a brief description of the collection in the Collection description field (optional).
9
Click Verify.
After the verification process is complete, the Verification Results pop-up appears, indicating whether the collection was verified successfully. In case the collection verification failed, the relevant error message is displayed.

The collections’ ID

The name of the column

The field type, as retrieved by the query (String, Integer and so on)

The column’s display name

The topology type for storage purposes. This type can be one of the following:

The metric’s unit of measurement.

The possible measurement unit values are: Percent, Count, Millisecond, Second, Minute, Hour, Day, Byte, Kilobyte, Megabyte and Gigabyte.

Used for defining the value that is displayed in this metric, out of several values that were returned in the relevant time range.

The available aggregation values are:

Indicates whether the field is the query’s key for retrieval.

Select True in this column to enable the collection of baseline statistics for this metric.

Except for the Column Name and Column Type fields, whose values are retrieved by the query and cannot be changed, all other fields can be edited by clicking any of them.
10
Ensure that all settings are appropriate, and click OK to finish the collection creation process.

Configuring the On-demand Data Port

Use the On-demand Data Settings view in the Databases Administration dashboard to define a port for each Foglight Agent Manager to be used by for retrieving data and integrating with Performance Analysis.

2
Click Set port.
4
Click Set.
5
Click Validate connectivity.

Changing the Monitoring Mode of the RAC One Node Agents

Use the RAC One Node view in the Databases Administration dashboard to change the monitoring mode of agents configured as RAC One Node, enabling the monitoring of such agents as regular RACs.

The Convert to Regular RAC dialog box appears, displaying one or more hosts.

After the selected host was converted to a physical RAC, use the Oracle Monitoring Installer wizard to add the other hosts monitored through this agent as nodes to the newly created RAC. For further details, see Using Foglight for Oracle .

Administering SQL Performance Investigator

The SQL Performance Investigator view in the Administration dashboard allows you to enable and disable SQL PI monitoring for selected agents. In addition, you can start and stop the collection of change tracking data.

In the SQL PI view, select one or more agents to enable or disable or for which to modify the change tracking status.

 

Related Documents