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

Defining the Collection Settings

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


Use the Locks pane to define the following settings:

Click Edit.
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.

Click Edit.
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.
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.
Use the Sort the collected SQL statements by list to select the field by which the Top SQL Statements list is to be sorted.
Use the Maximum size of short SQL statement field to type the maximum number of characters for the short SQL text.
Click Set to save these settings.

Tablespace Filtering

Use the Tablespace Filtering pane to configure the default monitoring settings for the Tablespaces Storage collection, by excluding from monitoring one or more of the following types of tablespaces:

This pane also includes the Tablespace Exclude List section. Use this section to add one ore more tablespaces to the Exclude list.

Click Add.
Click Add to complete the operation.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating