Chatta subito con l'assistenza
Chat con il supporto

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

Redo Archive Performance

The Redo Archive Performance collection provides redo and archive activity information.

Oracle

Realtime Collection

20

Online

60

Offline

300

Average Redo Write Time

The average time (ms) spent writing a redo log entry to the log files. User sessions experience log write waits when, upon commits, an individual session waits for the LGWR to flush its redo information to the redo log file.

Balance Archive Waits

The extent to which archive wait events are balanced across RAC nodes.

Balance Average Redo Write Time

The extent to which average redo write time is balanced across RAC nodes.

Balance Redo Waits

The extent to which average redo wait events are balanced across RAC nodes.

Balance Redo Writes

The extent to which redo writes are balanced across RAC nodes.

Commits

Number of transactions committed during the current interval. After a transaction is committed, the redo generated by that transaction reflects the changes made to database blocks, which must be written to disk.

Log File Sync Event

Average time spent on writing redo log entries during a commit.

Log Switch Wait

The time the session spent waiting for the completion of a redo log switch.

Log Write Wait

Time spent waiting for the completion of a write (physical I/O) to a logfile. LGWR experience log write waits when it periodically flushes the contents of the log buffer into the active log file.

Redo Waits

Elapsed redo wait time, including the time spent waiting on contention resulting from:

Redo Writes

Total number of write operations issued by the log writer (LGWR) to the redo log files.

Redo Writes Volume

Total amount (in megabytes) of redo operations generated and written to redo logs

Time to Sync a Redo Log Entry

Average time spent on writing single redo log entry to logfile during a commit.

Redo Instances Miscellaneous

The Redo Instances Miscellaneous collection provides Redo Log Switches information.

Oracle

Realtime Collection

3600

Online

3600

Offline

3600

Log Switches

The number of redo Logs switches during the specified time range

Redo Logs Member Storage

The Redo Logs Member Storage is a list of Redo log members and their properties.

Oracle

Realtime Collection

300

Online

900

Offline

3600

Group Number

The redo log group number

Member Name

The redo log group member name

Member Status

The redo log group member status is one of the following:

Redo Log Group

Redo Log Group name

Redo Log Storage

The Redo Log Storage collection provides a list of all Redo log groups and their overall properties.

Oracle

Realtime Collection

300

Online

900

Offline

3600

Archived

The archive status of the log file:

First change#

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

First Time

The time at which the first SCN in the log was recorded.

Group Status

The status of the group is one of the following:

This information is derived from the v$log table.

Group#

The log group number.

Sequence#

The sequence number.

Size

The size (in megabytes) of the log .

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione