Chat now with support
Chat with Support

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

Redo Logs Panel

Redo Logs Panel

The Redo Logs panel, which displays details regarding all redo logs, either for the Oracle instance or for all nodes of an Oracle RAC, comprises the following sections:

•
Redo Logs Storage Groups table — click on a group list row to see the list of members in that group.
•
Members of Group [n] table — for details, see Members of Group [n] Table .
Redo Logs Storage Groups Table

The redo log records all changes made in datafiles.

 
Table 24. Redo Logs Storage Groups Table
Name
Description

Group #

The redo log group number.

Group Status

The status of the redo logs indicates which logs are in use and whether there are any odd status codes, such as stale log indications or indications of corrupt redo logs.

The log files can have one of the following status values:

•
USED — indicates either that a log had just been added (never used), or that a RESETLOGS command has been issued.
•
CURRENT — indicates a valid log that is in use.
•
ACTIVE — indicates a valid log file that is not currently in use.
•
CLEARING — indicates a log is being re-created as an empty log due to database administrator action.
•
CLEARING CURRENT — indicates that a current log is being cleared of a closed thread. If a log stays in this status, it could indicate there is some failure in the log switch.
•
INACTIVE — indicates that the log is no longer needed for instance recovery but may be needed for media recovery.

Archived

Indicates if the redo logs are being archived.

Sequence #

The number assigned by Oracle to each redo log file whenever a log switch occurs and LGWR begins writing to the log file. When redo log files are archived, the archived log retains its log sequence number.

Size

The size of the log in megabytes.

First Change #

A system-allocated number (SCN), which identifies the first time a change was recorded in this log.

First Time

The time when the first SCN in the log was recorded.

Alarms

The number of warning, critical, and fatal alarms for the selected Oracle database tablespace.

Members of Group [n] Table

 
Table 25. Members of Group [n] Table
Name
Description

Member Name

The redo log group member name.

Member Status

The redo log group member status. This status can have one of the following values

•
INVALID — indicates that Oracle cannot access the redo log file.
•
STALE — indicates a log file that is either corrupt or incomplete. If the log file’s group becomes the active group, the file becomes valid again.
•
DELETED — indicates an online redo log file that has been dropped from the database and deleted from the disk.
•
IN USE — identifies the currently active redo log file.

Fast Recovery Area Panel

The Fast Recovery Area panel, which displays details regarding the allocated space for fast recovery area and its usage in the Oracle database, comprises the following sections:

* 
NOTE: If the fast recovery area is not configured in the database, the Fast Recover Area panel is blank, displaying only the message: “The Fast Recovery Area is not configured in the database.”
•
Current Usage details — shows details about the current usage of allocated space for fast recovery area.
•
Usage Breakdown pie chart — provides a representation of the current size of each component that occupies within the database's fast recovery area.
* 
NOTE: The pie chart displays only components which size is greater than zero.
•
Usage Space Distribution chart — shows the distribution among reclaimable and non-reclaimable parts of fast recovery area's used space.
•
Usage Details table — shows more detailed information about the space usage of the fast recovery area's components.
* 
NOTE: This table displays only components which size is greater than zero.
•
Flashback Database details — shows details about the oldest point in time to which is possible to flashback the database.
•
Flashback Data Size chart — shows the comparison among estimated size and current size of flashback data.

Archive Logs Panel

Archive Logs Panel

The Oracle database archive logs panel comprises the following sections:

•
Archive Log Destinations table
•
Archive Writes chart — displays the amount (in megabytes) of disk space being used per second for the archive log.
* 
NOTE: If the instance is configured not to archive, the Archive Logs panel is blank, displaying only the message “The database is not archiving”.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating