Chat now with support
Chat mit Support

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

Members of Group [n] Table

 
Table 24. 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”.

Archive Log Destinations Table

When monitoring a RAC, the contents of the Archive Log Destinations table vary between Whole Cluster and Instance/RAC node view, as in whole cluster view the table also includes the column Instance Name, as described below.

 
Table 25. Archive Log Destinations Table
Name
Description

Instance Name

Indicates which of the RAC nodes uses the specified destination archive file.

NOTE: The Instance Name column is displayed only in whole cluster view. From the Archive Destination column and forwards, the two tables are identical.

Archive Destination

The name of the destination archive file.

Destination Directory

The name of the destination directory.

Destination Status

The current status of the destination in v$archive_dest.

This destination can have one of the following values:

•
VALID — destination was initialized and is available
•
INACTIVE — no destination information exists
•
DEFERRED — destination was manually disabled by the user
•
ERROR — an error occurred during open or copy
•
DISABLED — disabled after error
•
BAD PARAM — parameter has errors
•
ALTERNATE — the destination is in an alternate state
•
FULL — the destination’s quota size has been exceeded

Destination Total

The total size of the archive destination target.

Destination Free Space

The total amount of free space available for the archive destination target.

Destination Usable

The total amount of usable space available for the archive destination target.

NOTE: The Destination Total, Destination Free Space, and Destination Usable columns display information only if the archive is managed using ASM and the ASM instance is installed and configured.

Time to Failure

The amount of time before the archive log destination becomes full.

Binding

The binding setting, which describes whether successful archival is required:

•
MANDATORY
•
OPTIONAL

Destination Type

The type of archived log destination — either PUBLIC or PRIVATE.

Transmit Mode

The mode in which data is transmitted across the network:

•
SYNCHRONOUS
•
ASYNCHRONOUS, or
•
PARALLELSYNC

Valid Type

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

•
ONLINE_LOGFILE
•
STANDBY_LOGFILE
•
ALL_LOGFILES
Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen