Dynamic Performance (V$) Views, 65 of 238

V$GC_ELEMENT

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

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