Foglight for Oracle (Cartridge) 5.9.3.20


Metric	Description
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

Purpose

The Backup Jobs collection collects RMAN jobs statuses.

Collection Type

Oracle

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	21600
Online	21600
Offline	21600

Metric Descriptions


Metric	Description
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

Purpose

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

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	21600
Online	21600
Offline	21600

Metric Descriptions


Metric	Description
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

Purpose

The Cluster Latency collection provides Cluster Latency and Activity data.

Collection Type

Oracle

Collection Sampling Settings


Frequency Mode	Collection Interval (Seconds)
Realtime Collection	20
Online	60
Offline	300

Metric Descriptions


Metric	Description
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. NOTE: This metric is not identical to the time elapsed before the block arrives at the requesting instance.
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.

Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.

Seleccionar calificación

Seleccione su producto:

Con el fin de ofrecerle un mejor servicio, complete el campo Motivo del chat:

Soluciones recomendadas para su problema

Foglight for Oracle (Cartridge) 5.9.3.20 - User Guide

Backup Config

Backup Jobs

Backup Type Status

Cluster Latency