Foglight for Oracle (Cartridge) 5.9.4.20


Metric	Description
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

Purpose

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

Collection Type

Oracle

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	300
Online	300
Offline	300

Metric Descriptions

Metric

Description

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:

•

VALID — initialized and available

•

INACTIVE — no destination information

•

DEFERRED — manually disabled by the user

•

ERROR — error during open or copy

•

DISABLED — disabled after error

•

BAD PARAM — parameter has errors

•

ALTERNATE — destination is in an alternate state

•

FULL — exceeded quota size for 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

Purpose

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

Collection Type

Oracle

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	3600
Online	3600
Offline	3600

Metric Descriptions


Metric	Description
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.