Chat now with support
Chat with Support

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

Alert Log

The Alert Log collection retrieves the content of Oracle alert log.

Oracle

Realtime Collection

300

Online

900

Offline

900

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

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

Oracle and Operating System

Realtime Collection

3600

Online

3600

Offline

3600

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:

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

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

Oracle

Realtime Collection

300

Online

900

Offline

3600

Archive Destination

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:

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:

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:

Target

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

Transmit Mode

The mode in which data is transmitted across the network:

Unarchived redo logs

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:

ASM Diskgroups

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

Oracle

Realtime Collection

300

Online

300

Offline

900

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.

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).

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.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating