Dynamic Performance (V$) Views, 130 of 179

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

INST_LOCK_REQUEST

NUMBER

Relevant only for Parallel Server. The mode instance lock is being requested in

INST_LOCK_RELEASE

NUMBER

Relevant only for Parallel Server. Whether the instance lock needs to be released

INST_LOCK_TYPE

VARCHAR2(2)

Relevant only for Parallel Server. The type of instance lock

INST_LOCK_ID1

RAW(4)

Relevant only for Parallel Server. The ID associated with the instance lock

INST_LOCK_ID2

RAW(4)

Relevant only for Parallel Server. The ID associated with the instance lock

KEY

RAW(100)

Relevant only for Parallel Server. The contents of the key

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
`INST_LOCK_REQUEST`	`NUMBER`	Relevant only for Parallel Server. The mode instance lock is being requested in
`INST_LOCK_RELEASE`	`NUMBER`	Relevant only for Parallel Server. Whether the instance lock needs to be released
`INST_LOCK_TYPE`	`VARCHAR2(2)`	Relevant only for Parallel Server. The type of instance lock
`INST_LOCK_ID1`	`RAW(4)`	Relevant only for Parallel Server. The ID associated with the instance lock
`INST_LOCK_ID2`	`RAW(4)`	Relevant only for Parallel Server. The ID associated with the instance lock
`KEY`	`RAW(100)`	Relevant only for Parallel Server. The contents of the key