Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-14
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$ROWCACHE_PARENT

V$ROWCACHE_PARENT displays information for parent objects in the data dictionary. There is one row per lock owner, and one waiter for each object. This row shows the mode held or requested. For objects with no owners or waiters, a single row is displayed.

Column Datatype Description
INDX NUMBER Index of the row
HASH NUMBER Hash value
ADDRESS RAW(4 | 8) Address of the parent object
CACHE# NUMBER Parent cache ID
CACHE_NAME VARCHAR2(64) Parent cache name
EXISTENT VARCHAR2(1) Indicates whether the object is an existing object
LOCK_MODE NUMBER Mode the lock is held in
LOCK_REQUEST NUMBER Mode the lock is requested in
TXN RAW(4) Transaction currently locking the object
SADDR RAW(4 | 8) Address of the session
INST_LOCK_REQUEST NUMBER Mode in which instance lock is being requested. This column is only relevant for Real Application Clusters.
INST_LOCK_RELEASE NUMBER Whether the instance lock needs to be released. This column is only relevant for Real Application Clusters.
INST_LOCK_TYPE VARCHAR2(2) Type of instance lock. This column is only relevant for Real Application Clusters.
INST_LOCK_ID1 RAW(4) ID associated with the instance lock. This column is only relevant for Real Application Clusters.
INST_LOCK_ID2 RAW(4) ID associated with the instance lock. This column is only relevant for Real Application Clusters.
KEY RAW(100) Contents of the key. This column is only relevant for Real Application Clusters.