Chat now with support
Chat with Support

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

Invalid Objects Filtering

Use the Exclude List pane to excluding specific schemas from being monitored by the Invalid Objects collection.

Click Add a Schema to the Exclude List.
Click Add.

Configuring the Alert Log Filtering Panel Display

Use the Alert Log Filtering view to configure the retrieval and display settings for the Alerts > Alert Log panel. In addition, this view is used to define default settings for invoking alarms based on the collected alerts.

Use this view to define the following settings:

Display under a pre-defined name in the Alert Log panel — using the Match List pane. This pane contains a default list of expressions within the alert logs that are to be retrieved and displayed in the Alert Log panel under a pre-defined name, category and severity.
Exclusion from the Alert Log panel display — using the Ignore List pane, which contains a default list of alerts that are to be excluded when setting the alert logs display.

Both the Match List and the Ignore List panes can be customized by adding, editing or removing alert logs. Each filter can be enabled or disabled separately by clicking Edit and selecting or clearing the Enabled check box. Alternatively, to enable or disable all of the filters, click the Enable All or Disable All button.

Click Add.
Expression — identifies the text that is to be extracted as a message from the alert log and displayed in the Message column of the Alert Log panel > Alert Log Messages table. This text usually contains the beginning of the message and a wildcard (for example: ORA-12012.*).
Click Add to save your settings.
Click Edit.
Click Set to save your settings.

Configuring the List of Listeners per Instance

Use the Listeners Monitoring view in the Databases Administration dashboard to edit the list of monitored listeners per instance, by adding or removing listeners from the list.

Open the drop-down list below the title Please select an agent:, to display the entire list of selected agents.
Click Add Listener.
The contents of the Add a Listener dialog box that appears now vary between Windows and UNIX. For instructions for Windows-based agent, go to Step 4.
Click Add.
Click Edit Listener.
Click Set to apply the changes or Cancel to revert to the previous settings.
Click Delete Listener.
Click Yes to confirm the deletion or Cancel to keep monitoring the listener.

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:

Click Add.
Click Edit credentials.
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.
Click Set details.
Enter a name in the Collection name field.
Enter a brief description of the collection in the Collection description field (optional).
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.
Ensure that all settings are appropriate, and click OK to finish the collection creation process.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating