Chat now with support
Chat with Support

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

Locks

Use the Locks pane to define the following settings:

•
The maximum number of blocked segments to be displayed in the Lock Overview pane of the Activity > Locks panel.
•
The minimal duration, in seconds, which a lock should reach or exceed in order to be collected. All locks that meet this criterion are displayed in the lower section of the Locks Historical Tree pane.
To modify the lock collection and display settings:
1
Click Edit.
The Edit Lock Collection and Display Settings dialog box opens.
2
Use the designated field to type the maximum number of blocked segments.
3
Use the designated field to type the minimal duration for collecting and displaying a lock in the Locks Historical Tree.
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.

To define the settings for collecting and displaying SQL statements:
1
Click Edit.
The Edit Top SQL Statements Setting s dialog box opens.
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.
The possible values are:
•
CPU Time — the total CPU time consumed for carrying out the SQL statement executions
•
Elapsed Time — the total time consumed for carrying out the SQL statement executions
•
Executions — the number of times the SQL script executed for a unique SQL Handle
•
Total Waits — the total wait time spent while executing the SQL statements
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.
7
At the bottom of the view, click Save changes.

Tablespace Filtering

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:

•
Undo tablespaces
•
Temporary tablespaces
•
Read-only tablespaces
•
System-Sysaux tablespaces

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

To add tablespaces to the Exclude list:
1
Click Add.
The Add a Tablespace to the Exclude List dialog box opens.
2
Use the Tablespace name field to enter a field name. To exclude multiple tablespaces, insert a regular expression (wild card) and select the Regex check box.
3
Click Add to complete the operation.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating