Foglight for Oracle (Cartridge) 5.9.5.20


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.

Cluster Misses

Purpose

The Cluster Misses collection collects data regarding global cache misses.

Collection Type

Oracle

Collection Sampling Settings


Frequency Mode	Collection Interval
Realtime Collection	20
Online	60
Offline	300

Metric Descriptions


Metric	Description
2-way Misses	The number of current and consistent blocks that were received by the selected instance from a specific instance, after a 2-way roundtrip.
3-way Misses	The number of current and consistent blocks that were received by the selected instance from a specific instance, after a 3-way roundtrip.
Consistent Blocks 2-way Misses	The number of consistent blocks that were received by the selected instance from a specific instance, after a 2-way roundtrip.
Consistent Blocks 3-way Misses	The number of consistent blocks that were received by the selected instance from a specific instance, after a 3-way roundtrip.
Consistent Blocks Misses	The number of consistent blocks that were received by the selected instance from a specific instance, after a 2-way or 3-way roundtrip.
Current Blocks 2-way Misses	The number of current blocks that were received by the selected instance from a specific instance, after a 2-way roundtrip.
Current Blocks 3-way Misses	.The number of current blocks that were received by the selected instance from a specific instance, after a 3-way roundtrip
Current Blocks Misses	The number of current blocks that were received by the selected instance from a specific instance, after a 2-way or 3-way roundtrip.

Datafile Fragmentation

Purpose

The Datafile Fragmentation collection collects information regarding the layout of the free space left in the datafile due to fragmentation.

Collection Type

Oracle

Collection Sampling Settings

None (on-demand collection).

Metric Descriptions


Metric	Description
Datafile name	The name of the datafile
Extent Size	Offset end of the extent from the beginning of the file.
Extent Start	Offset start of the extent from the beginning of the file.
Extent Type	Defines the type of the extent: Used, Fully Usable, Partly Usable or Unusable.
Sequence ID	The datafile’s sequence ID.

Datafile IO Activity

Purpose

The Datafile IO Activity collection collects metrics and performance ratios related to datafile I/O activity.

Collection Type

Oracle

Collection Sampling Settings


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

Metric Descriptions


Metric	Description
Avg IO Time	Average time spent on a single IO request for a specific datafile
Avg Read Time	Average time spent on a single physical read request for a specific datafile
Avg Write Time	Average time spent on a single physical write request for a specific datafile
Contents	The type of the tablespace contents (temporary, permanent, undo)
File Full Name	The name of the datafile (including full path)
File ID	The datafile ID
File Name	The name of the datafile (without the path)
File Path	The datafile path
IO Time	The total time spent on carrying out IO operations (reading and writing data) on a specific datafile
Last IO Time	The time spent while performing last I/O operation on a specific datafile
Max Single Read Time	The maximum time spent while reading a single block from a specific datafile
Max Single Write Time	The maximum time spent while writing a single block to a specific datafile
Min Single IO Time	The minimum time spent while reading a single block from a specific datafile
PDB	In multitenant architectures, the name of the pluggable database.
Physical IO	Total size, in blocks, of all disk reads and writes for a specific datafile
Physical IO Percent	The IO activity (block reads + block writes) for a specific datafile as a percentage of the total IO activity for all datafiles
Physical Reads	The number of data blocks read by Oracle, which are not present in the buffer cache or in the PGA, thereby requiring I/O read operations, that is: the total number of data blocks read from disk.
Physical Reads Percent	The block reads carried out for a specific datafile as a percentage of the of total block reads carried out for all datafiles
Physical Writes	Total size in blocks of all disk writes for a specific datafile
Physical Writes Percent	The block writes carried out for a specific datafile as a percentage of the of total block writes carried out for all datafiles
Read Requests	The number of read requests for a specific datafile that read one or more database blocks per request.
Read Time	The total time spent on reading data from a specific datafile.
Single Block Read Time	The total time spent on read requests that read one database block per request from a specific datafile.
Single Block Reads	Number of read requests for a specific datafile, which read one database block per request.
Tablespace Name	The tablespace name.
Write Requests	The number of write requests for a specific datafile that wrote one or more database blocks per request.
Write Time	The total time spent on writing data to specific datafile.

Seleziona il prodotto:

Per una maggiore efficacia, compilare l'Obiettivo della chat:

Soluzioni consigliate per il problema

Foglight for Oracle (Cartridge) 5.9.5.20 - User Guide

Cluster Latency

Cluster Misses

Datafile Fragmentation

Datafile IO Activity