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

Defining Retention Policies

Use the Retention Policies view in the Databases Administration dashboard to define the requested duration for which each of the metric collections, which are defined in the Collections view, are to be kept.

Data can be retained for brief, moderate, or long periods, by selecting one of the following options:

3
Click Set to apply the selected setting or Cancel to reject the setting.

Defining the Collection Settings

Use the Collection Settings view to limit the number of displayed items for each of the collections below.

Locks

Use the Locks pane to define the following settings:

1
Click Edit.
4
Click Set to approve the new setting or Cancel to undo the operation.

Top SQL Statements

Use the Top SQL Statements pane to configure the requested settings for top SQL statements, that is, statements that generated the maximal workload, as defined by the criterion by which the selected SQL statements are sorted. Use this pane to define the criterion of top SQL statements, as well as the maximum number of such statements to be retrieved and displayed. Top SQL statements are displayed on the Activity > Top SQL Statements panel.

1
Click Edit.
2
Use the Maximum number of displayed SQL statements field to enter the maximum number of SQL statements that are to be displayed in the Top SQL Statements grid.
3
Use the Maximum number of retrieved SQL statements field to enter the number of SQL statements that generated the maximal workload and are to be saved to the Top SQL statements collection.
4
Use the Sort the collected SQL statements by list to select the field by which the Top SQL Statements list is to be sorted.
5
Use the Maximum size of short SQL statement field to type the maximum number of characters for the short SQL text.
6
Click Set to save these settings.
Related Documents