Chat now with support
Chat with Support

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

Datafiles Storage

The Datafiles Storage collection provides a list of all datafiles and their overall properties and storage details.

Oracle and Operating System

Realtime Collection

900

Online

900

Offline

3600

Autoextend

Indicates whether the datafile is autoextensible.

Autoextensible

Indicates if at least one datafile in the database is not autoextensible

File ID

The ID of the selected datafile.

File Name

The name of the datafile.

Filesystem Name

The name of the file system where the datafile resides.

Free

The amount of free space on the selected datafile.

Free Pct

The percentage of free space on the selected datafile.

Is ASM File

Indicates whether the datafile is an Automatic Storage Management (ASM) file.

Maximum Used Percent

The maximum percent of the used disk space of all the database datafiles.

Maxsize

The maximum size of this datafile; used for autoextensible datafiles.

PDB

In multitenant architectures, the name of the pluggable database.

Size

The size of the datafile (in megabytes).

Status

Indicates whether the datafile is available or invalid.

Tablespace Name

The name of the table space to which the datafile belongs.

Total Allocated Space

The total allocated space in the database.

Total Allocated Space Delta

 

Total Free Space Percent

The percentage of free space in the database datafiles.

Used

The size (in megabytes) of used datafile storage.

Used Pct

The percentage of used datafile storage.

Dataguard Destination Status

The Dataguard Destination Status collection retrieves status and statistics for standby destinations in Data Guard.

Oracle

Realtime Collection

300

Online

300

Offline

300

Destination Directory

The Data Guard destination directory

Destination Error

Displays the error message for destination status.

Destination ID

The destination ID

Destination Status

Identifies the current status of the destination:

Gap in Applied Logs

The gap between the last archive log on the primary database and last applied archive log on the standby database.

Gap in Received Logs

The gap between the last archive log on the primary database and the last received archive log on standby database.

Last Applied Sequence#

Number of the last applied sequence

Last Dataguard error

The most recent error reported by Oracle for this standby destination

Last Dataguard message

The most recent Data Guard message reported by Oracle for this standby destination.

Last Received Sequence#

Number of the last received sequence.

Dataguard Redo Apply

The Dataguard Redo Apply Rates collection retrieves performance data for database configured with Data Guard.

Oracle

Realtime Collection

3600

Online

3600

Offline

3600

Destination ID

The destination ID

Rate of Redo Apply

The amount of MB of the redo logs applied to the standby database.

Rate of Redo Receive

The amount of MB of the redo logs received on the standby database.

Dataguard Status

The Dataguard Status collection retrieves general definitions and status of database configured with Data Guard.

Oracle

Realtime Collection

300

Online

300

Offline

300

Database Role

The database role

Number of Logs not Applied on Standby

Number of logs that were not applied on standby mode.

Number of Logs not Received on Standby

Number of logs that were not received on standby mode.

Number of Online Redo Logs

The number of Online redo logs defined for the standby database.

Number of Standby Redo Logs

The number of Standby redo logs defined for the standby database.

Protection Level

Aggregated protection mode currently in effect for the database:

Protection Mode

Protection mode currently in effect for the database:

Redo Logs Configuration Mismatch

The number of online redo logs and the number of standby redo logs on the primary database do no match.

Total Number of Dataguard Errors

The number of Data Guard errors reported by Oracle for the standby database.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating