Database Reference
In-Depth Information
Figure 14-13. Cluster database performance
The EM cluster cache coherency screen (Figure 14-14 ) is also a tool to monitor cluster interconnect performance.
The figure displays three important matrixes:
Global Cache Block Access Latency : This represents the elapsed time from when the
block request was initiated until it completes. However, when a database block of any class
is unable to locate a buffered copy in the local cache, a global cache operation is initiated
by checking if the block is present in another instance. If it is found, it is shipped to the
requestor.
Global Cache Block Transfer Rate : If a logical read fails to find a copy of the buffer in the
local cache, it attempts to find the buffer in the database cache of a remote instance. If the
block is found, it is shipped to the requestor. The global cache block transfer rate indicates
the number of blocks received.
Block Access Statistics : This indicates the number of blocks read and the number of blocks
transferred between instances in a RAC cluster.
 
Search WWH ::




Custom Search