Chatta subito con l'assistenza
Chat con il supporto

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

Top SQLs Full Text

This collection retrieves the SQL statement’s full text.

Oracle

The Top SQLs Full Text collection is an on-demand collection, which retrieves data only upon clicking View full text.

Hash Value

The SQL statement’s hash value

SQL Full Text

Full text for the SQL statement exposed as a Character Large OBjects (CLOB) column

Top SQLs Text

The Top SQLs Text collection retrieves the first n characters of the skoal statement text (the exact number of the characters is defined in the Top SQL Statements pane of the Collection Settings screen).

Oracle

This collection retrieves SQL text only for new hash values.

Hash Value

The SQL statement’s hash value.

Is Full Text

A boolean value that indicates whether the first n characters are a full or partial SQL text for the current cursor.

SQL Text

First n characters of the SQL text for the current cursor.

Total Archive Storage

The Total Archive Storage collection collects disk space data for critical archive destinations.

Oracle

Realtime Collection

300

Online

900

Offline

3600

Archive Destination Free Space

The free space size (in megabytes) in the file system where the most critical archive destination resides.

Archive Destination Size

The total size (in megabytes) of the file system where the most critical archive destination resides.

Critical Archive Time To Failure

The number of hours remaining until the archive

destination with the shortest time to failure is filled.

Destination

The destination ID of the most critical archive destination.

Total Database Storage

The Total Database Storage collection retrieves the database’s total storage, that is: the summarized value of total free space and total allocated space.

Oracle

Realtime Collection

300

Online

900

Offline

3600

Maximum Used Percent

The maximum percent of the used disk space of all the

database datafiles.

Total Allocated Space

The total size (in megabytes) of allocated space in the database.

Total Allocated Space Delta

The incremental change in the total size of the database’s allocated space during the specified time range.

Total Allocated Space Rate

The rate (in megabytes/seconds) at which disk space was allocated on the database during the last sample.

Total Free Space Percent

The percent of the total free disk space within the database.

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione