What do the Oracle Cluster Interconnect Latency metrics represent?
説明
In SQL PI, when selecting a Node from a RAC in the pulldown, and then clicking Cluster in the second menu at the top, an Interconnect Activity Tab is available as a set of metrics.
What do the Oracle Interconnect Latency metrics refer to?
対策
The metrics below Interconnect Latency represent the following waits
Latency
Latency - is the Cluster Latency rate in ms/blocks.
CR Block Request Latency
Send Latency - is the gc_cr_block_send_time_rate in ms/millisecond, this is the average global cache CR block send time rate being experienced from this instance across the RAC Interconnect.
Flush Latency - gc_cr_block_flush_time_rate in ms/millisecond, this is the average global cache CR block flush rate being experienced from this instance across the RAC Interconnect.
Build Latency - gc_cr_block_build_time_rate in ms/millisecond, this is the average global cache CR block build rate being experienced from this instance across the RAC Interconnect.
Current Block Request Latency
Send Latency - gc_current_block_send_time_rate in ms/millisecond, this is the average current block send rate being experienced from this instance across the RAC Interconnect.
Flush Latency - gc_current_block_flush_time_rate in ms/millisecond, this is the average current block flush rate being experienced from this instance across the RAC Interconnect.
Pin Latency - gc_current_block_pin_time_rate in ms/millisecond, this is the average current block pin rate being experienced from this instance across the RAC Interconnect.
Note: The ms/millisecond in the metric represents ms of activity per ms of clock time
Enhancement Request FOG-5505 has been logged to change the metric from Sessions to MS/millisecond in a future release of the Oracle cartridge.