Chatta subito con l'assistenza
Chat con il supporto

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

•
Short — retains data up to one month.
•
Medium — retains data up to three months.
•
Long — retains data up to one year.
To modify the retention policy:
1
Click the text that displays the current retention policy.
The Edit the Retention Policy dialog box opens.
2
Select the requested retention policy scheme from the list.
3
Click Set to apply the selected setting or Cancel to reject the setting.
4
At the bottom of the view, click Save changes.

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.
Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione