Oracle RAC Cache Fusion Monitoring Views

Oracle RAC Cache Fusion Monitoring Views

View Name Description
V$HVMASTER_INFO Contains information about resources controlled by GES.
V$GCSPFMASTER_INFO Provides information about which node is the master of files in the database.
V$GCSHVMASTER_INFO Lists information about resources controlled by GCS.
V$CACHE_TRANSFER This view contains blocks that have been read or forced writes by another node in the cluster when the current node had the block in its cache.
V$CR_BLOCK_SERVER This view contains stats about consistent read block transfers between nodes.
V$CURRENT_BLOCK_SERVER This view contains stats about current block transfers to other nodes.
V$GC_ELEMENT Contains stats about global cache resources current in use.
V$GES_BLOCKING_ENQUEUE Contains information about global locks that are blocking other session from obtaining a lock.
V$GES_RESOURCE Provides a list of resources tracked by the GES.
V$CONFIGURED_INTERCONNECTS Provides information about all of the interconnects Oracle has been configured with.
V$CLUSTER_INTERCONNECTS Contains information about the cluster interconnects.
V$INSTANCE_CACHE_TRANSFER This provides information about blocks being transferred through the interconnect.
V$GES_ENQUEUE Provides information about global locks
V$GES_CONVERT_REMOTE Provides information about the time it takes to convert a lock on remote nodes.
V$GES_CONVERT_LOCK Provides information about the time it takes to convert a lock on the local node.
V$GES_STATISTICS Provides stats about GES.

Block transfer times by the LMS process within RAC can be determined using the formula below with values from V$SYSSTAT or GV$SYSSTAT:

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."