V$GC_ELEMENT

This is a Real Application Clusters view. There is one entry in V$GC_ELEMENT for each global cache resource that is used by the buffer cache. The name of the global cache resource that corresponds to a lock element is {'BL', indx, class}.

See Also:

Oracle Real Application Clusters Installation and Configuration Guide

Column	Datatype	Description
`GC_ELEMENT_ADDR`	`RAW(4 \| 8)`	Address of the lock element that contains the PCM lock that is covering the buffer. If more than one buffer has the same address, then these buffers are covered by the same PCM lock.
`INDX`	`NUMBER`	Platform specific lock manager identifier
`CLASS`	`NUMBER`	Platform specific lock manager identifier
`GC_ELEMENT_NAME`	`NUMBER`	Name of the lock that contains the PCM lock that is covering the buffer
`MODE_HELD`	`NUMBER`	Platform dependent value for lock mode held; often: 3 = share; 5 = exclusive
`BLOCK_COUNT`	`NUMBER`	Number of blocks covered by PCM lock
`RELEASING`	`NUMBER`	Nonzero if PCM lock is being downgraded
`ACQUIRING`	`NUMBER`	Nonzero if PCM lock is being upgraded
`INVALID`	`NUMBER`	Nonzero if PCM lock is invalid (a lock may become invalid after a system failure)
`FLAGS`	`NUMBER`	Process level flags for the lock element