V$GC_ELEMENT displays one entry 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}. This is a Real Application Clusters view.
| 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 |
WRITING |
NUMBER |
If the GC_ELEMENT is being written, the write status |
RECOVERING |
NUMBER |
If the GC_ELEMENT is being recovered, the recovery status |
LOCAL |
NUMBER |
Zero if the GC_ELEMENT is local, one if it is global |
FLAGS |
NUMBER |
Process level flags for the lock element |