V$ROWCACHE_PARENT

This view 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	The hash value
ADDRESS	RAW(4)	The address of the parent object
CACHE#	NUMBER	The parent cache ID
CACHE_NAME	VARCHAR2(64)	The parent cache name
EXISTENT	VARCHAR2(1)	Whether the object is an existing object
LOCK_MODE	NUMBER	The mode the lock is held in
LOCK_REQUEST	NUMBER	The mode the lock is requested in
TXN	RAW(4)	The transaction currently locking the object
SADDR	RAW(4)	The address of the session
Note: The following are relevant only for Oracle Real Application Clusters.
INST_LOCK_REQUEST	NUMBER	The mode in which instance lock is being requested
INST_LOCK_RELEASE	NUMBER	Whether the instance lock needs to be released
INST_LOCK_TYPE	VARCHAR2(2)	The type of instance lock
INST_LOCK_ID1	RAW(4)	The ID associated with the instance lock
INST_LOCK_ID2	RAW(4)	The ID associated with the instance lock
KEY	RAW(100)	The contents of the key