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 | 8)

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.

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data