Chat now with support
Chat with Support

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

Backup Config

The Backup Config collection provides a list of configuration parameters value for RMAN.

Oracle

Realtime Collection

21600

Online

21600

Offline

21600

Configuration #

The number of configuration parameters

Configuration Name

The names of the configuration parameters

Configuration Value

The values of the configuration parameters

Database

Database name

Backup Jobs

The Backup Jobs collection collects RMAN jobs statuses.

Oracle

Realtime Collection

21600

Online

21600

Offline

21600

Backup Job ID

The ID of the backup job

Backup Job Status

The status of the backup job

Backup Job Type

The type of the backup job

Database

Database name

Job End Time

The end time of the backup job

Job Start Time

The start time of the backup job

Output

The output message of the backup job

Session Rec ID

The Oracle identifier of the RMAN job

Session Stamp

The time stamp of the session

Backup Type Status

Backup Type Status collection collects the last time stamp of each RMAN job that ran successfully.

Realtime Collection

21600

Online

21600

Offline

21600

Backup Type

The type of the backup job.

Days Since Backup

The number of days that passed since the last database backup.

Last Successful Backup

The date of the most recent successful backup that has been carried out for the database.

Cluster Latency

The Cluster Latency collection provides Cluster Latency and Activity data.

Oracle

Realtime Collection

20

Online

60

Offline

300

Average Global Cache Convert Time

Average amount of time required for the completion of global conversions on GCS resources.

Average Global Lock Convert Time

Average amount of time required for the completion of synchronous and asynchronous global lock converts.

Average Global Lock Get Time

Average amount of time required for the completion of synchronous and asynchronous global lock gets.

Balance

Interconnect Load balance between the various cluster nodes.

Block Received Latency

The average transfer time of a block from another instance.

Block Sent Latency

The average time needed to prepare a requested block.

Blocks Corrupt Percent

The percentage of global cache blocks that encountered a corruption or checksum failure within the entire number of global cache blocks sent over the Interconnect.

Blocks from Interconnect

The number of blocks received from Interconnect after the requests for blocks were not satisfied from the local instance, and therefore had to make a request for the block from the remote.

Blocks to Interconnect

The number of blocks sent via Interconnect after the requests for blocks were not satisfied on the requesting instance, and therefore had to make a request for the block from the local instance.

Blocks/sec from Interconnect

The rate per second of blocks received from Interconnect after the requests for blocks were not satisfied from the local instance, and therefore had to make a request for the block from the remote.

Blocks/sec to Interconnect

The rate per second of blocks sent via Interconnect after the requests for blocks were not satisfied on the requesting instance, and therefore had to make a request for the block from the local instance.

Cluster Latency Rate

The average time it took to transfer a block through the Interconnect, that is, the time that has elapsed since the request for the block was submitted until the block was received by the requesting instance.

Consistent Gets

The number of times a consistent read was requested for a block by this session

CR Blocks Send Time

Total amount of time spent sending constructed CR Blocks through the Interconnect.

Current Block Send Time

Total amount of time spent sending Current Blocks through the Interconnect.

DB Block Gets

The number of data block reads in CURRENT mode (namely, current reads).

GC Blocks Corrupt

The total number of global cache blocks that encountered a corruption or checksum failure during the specified time range As such failures occur during data transfer, high values of this metric can indicate network-related issues.

GC Blocks Lost

Total number of global cache blocks lost during the specified time range. As the loss of global cache blocks takes place during data transfer, high values of this metric can indicate network-related issues.

GC CR Block Build Time

The average time taken by an LMS process to create a consistent read block on a holding instance within the cluster.

GC CR Block Flush Time

The average time taken by the LGWR (log writer) process to flush any changes required to a buffer on the log flush queue.

GC CR Block Receive Time

Total amount of time foreground processes spent waiting for a CR block to be sent through the Interconnect.

GC CR Block Send Time

The average time taken by an LMS process to initiate the sending of a consistent read block. This is NOT the same as the time elapsed before the block arrives at the requesting instance.

GC CR Blocks Received

Total number of consistent read data blocks that Oracle processes did not find in their local cache and had to fetch from the global cache, using a consistent read request.

GC CR Blocks Served

Total number of blocks constructed by the Block Server Process (BSP).

GC Current Block Flush Time

The average time taken by the LGWR (log writer) process to flush the changes from a block to disk (a forced log flush) before the block is shipped to the requesting instance.

GC Current Block Pin Time

The average time taken by an LMS process to pin the current block before shipping it to the requesting instance.

GC Current Block Receive Time

Total amount of time foreground processes waited for a current block to be sent through the Interconnect.

GC Current Block Send Time

The average time taken by an LMS process to initiate the sending of a current block.

GC Current Blocks Received

Total amount of time foreground processes waited for a current block to be sent through the Interconnect.

GC Current Blocks Served

The number of current blocks shipped to the requesting instance over the hardware Interconnect.

Global Cache Convert Time

Total amount of time spent waiting for global cache converts on all sessions.

Global Cache Converts

Resource converts of buffer cache blocks. This statistic is incremented whenever GCS resources are converted from Null to Exclusive, Shared to Exclusive, or Null to Shared.

Global Lock Convert Time

Total time spent waiting for all synchronous and asynchronous global lock converts.

Global Lock Get Time

Total elapsed time of all synchronous and asynchronous global lock gets.

Global Lock Releases

Total number of synchronous global lock releases.

Global Lock Sync Converts

The total number of resources that Oracle converted from an incompatible mode during the selected time range.

Interconnect Block Latency

The average time it takes to prepare and transfer a block across the Interconnect network.

Lost Blocks Ratio

The ratio of global cache blocks losses during data transfer via the Interconnect.

Received from Interconnect Time

Total amount of time the foreground processes waited for blocks to be sent through the Interconnect

Sent to Interconnect Time

Total amount of time spent sending blocks through the Interconnect

Total CR Blocks

The total number of CR blocks that were served/received through the Interconnect

Total Current Blocks

The total number of current blocks that were served/received through the Interconnect.

Total I/C Load

Total number of blocks (both CR and current) that were served and received from the Interconnect.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating