Chat now with support
Chat with Support

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

Total Instance Waits

The Total Instance Waits collection collects the total amount of time (in seconds) that the instance spent on wait events since the last sample.

Oracle

Realtime Collection

60

Online

300

Offline

900

Total Waits

The total amount of time (in seconds) that the instance spent on wait events since the last sample.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating