Foglight for Oracle (Cartridge) 5.9.2.1


Metric	Description
Critical Errors	The number of critical error notifications that were received during the specified time range.
Dump File Name	Indicates the name of dump file (if this name appears in the alert log message).
Fatal Errors	The number of fatal error notifications that were received during the specified time range.
Informational Errors	The number of informational messages that were received during the specified time range.
Message	The text of the alert log message.
Name	The name of the alert log message.
Severity	Indicates the alert log message severity (Fatal, Critical, Warning, Informational).
Timestamp	Alert log message timestamp.
Type	Alert log message type (Internal Error, Storage, Media Failure and so on).
Warning Errors	The number of warning error notifications that were received during the specified time range.

Archive Destination Miscellaneous

Purpose

The Archive Destination Miscellaneous collection provides Archive Destinations activity rates and time considerations.

Collection Type

Oracle and Operating System

Collection Sampling Settings


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

Metric Descriptions

Metric

Description

Archive Destination Free Space

The free space in the file system where the most critical archive destination is located.

Archive Destination Size

The size of the file system where the most critical archive destination is located.

Archive Rate

The rate of the archiving operation.

Archiving Volume

Archiving volume

Average Archive File Size

The size of the average archive file

Binding

Binding type:

•

MANDATORY — successful archival is required.

•

OPTIONAL — successful archival is not required.

Critical Archive Time To Failure

The number of hours left until the critical archive destination fills.

Database

The database name.

Destination

The destination ID of the most critical archive destination.

Destination directory

The archive’s destination directory

Destination Free Space

The total amount (in megabytes) of free space available for the archive destination target.

Destination Total

The total size (in megabytes) of the archive destination target.

Time To Failure

The number of hours remaining until the archive destination with the shortest time to failure is filled.

Archive Logs Storage

Purpose

The Archive Logs Storage collection provides Archive Destinations properties and file systems space data.

Collection Type

Oracle

Collection Sampling Settings


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

The name of the destination archive file.

Archiver Status

The archiver status; can have one of the following values: Stopped, Started, and Failed.

Binding

Binding type:

•

MANDATORY — successful archival is required.

•

OPTIONAL — successful archival is not required.

Database

Database name

Destination Directory

The directory used for storing the archive.

Destination End

The value of destination directory is replaced by Recovery Destination if the directory is used for recovery.

Destination Free Space

The total amount (in megabytes) of free space available for the archive destination target.

Destination Total

The total size (in megabytes) of the archive destination target.

Destination Type

The type of the archived log destination:

•

PUBLIC

•

PRIVATE

Destination Usable

The amount (in megabytes) of storage space usable for the archive logs in the destination directory.

Error

Displays the error text.

If database in archive mode

Indicates whether the database is in archive mode

Is ASM

Indicates whether the instance is an Automatic Storage Management (ASM) instance

Is Recovery

Indicates whether the directory is used for recovery (True) or not (False).

Log Sequence

Identifies the sequence number of the most recently archived redo log.

Multiple destinations in filesystem

Indicates if more than one archive destinations reside on the same filesystem.

Re-open

Identifies the retry time (in seconds) to open a destination after error.

Space Reclaimable

The amount of space that can be used if files are removed from the Flash Recovery Area.

Status

The current status of the destination in V$ARCHIVE_DEST:

•

•

•

•

•

•

•

•

Specifies whether the archive destination is local or remote to the primary database:

•

PRIMARY - local

•

STANDBY - remote

Transmit Mode

The mode in which data is transmitted across the network:

•

•

•

The percentage of redo logs files that are waiting for archiving

Valid Type

The redo log type or types that are valid for the destination:

•

ONLINE_LOGFILE

•

STANDBY_LOGFILE

•

ALL_LOGFILES

ASM Diskgroups

Purpose

The ASM Diskgroups collection collects storage and activity data regarding ASM Diskgroups.

Collection Type

Oracle

Collection Sampling Settings


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

Metric Descriptions


Metric	Description
Allocation Size Unit	The size of allocation units in the disk group.
ASM Metadata Block Size	The block size for ASM metadata in the disk group.
Average Service Time	The average service time for all disks in the group.
Group Name	The name of the disk group.
Group Number	The number assigned to an ASM disk group.
Group State	The state of the specified ASM disk group relative to the Oracle instance (CONNECTED, BROKEN, UNKNOWN, DISMOUNTED, or MOUNTED).
Number of Disks	The number of disks in the disk group.
Offline Disks	The number of disks in the disk group that are offline. NOTE: This information is unavailable for Oracle 10.1
Read Errors	The total number of failed I/O read requests for the disk group.
Read IO Requests	The total number of I/O read requests for the disk group.
Total Group Size	The total capacity of the specified ASM disk group (in megabytes).
Usable Group Space	The unused space on the disk group (in megabytes). NOTE: This information is unavailable for Oracle 10.1
Used Group Space	The percentage of used disk space on the entire disk group. This value is calculated as follows: 100*(Total Group Size - Usable Group Space) Total Group Size
Write Errors	The total number of failed I/O write requests for the disk group.
Write IO Requests	The total number of I/O write requests for the disk group.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

Foglight for Oracle (Cartridge) 5.9.2.1 - User Guide

Alert Log

Archive Destination Miscellaneous

Archive Logs Storage

ASM Diskgroups