Chat now with support
Chat with Support

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

Overview of Collections

Foglight for Oracle collects raw data for a set of collection types. This data is used by the Rules to trigger alarms and is used to populate dashboards. The collections data tables are not viewable from Foglight for Oracle, but the data is implemented in the various drilldowns of Foglight for Oracle.

The collection data tables are not viewable from Foglight for Oracle.

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:

Related Documents