[Home] [Help] [Dependency Information]
Object Name: | GV_$ROWCACHE_PARENT |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
INDX | NUMBER | |||
HASH | NUMBER | |||
ADDRESS | RAW | (8) | ||
CACHE# | NUMBER | |||
CACHE_NAME | VARCHAR2 | (64) | ||
EXISTENT | VARCHAR2 | (1) | ||
LOCK_MODE | NUMBER | |||
LOCK_REQUEST | NUMBER | |||
TXN | RAW | (8) | ||
SADDR | RAW | (8) | ||
INST_LOCK_REQUEST | NUMBER | |||
INST_LOCK_RELEASE | NUMBER | |||
INST_LOCK_TYPE | VARCHAR2 | (2) | ||
INST_LOCK_ID1 | RAW | (4) | ||
INST_LOCK_ID2 | RAW | (4) | ||
KEY | RAW | (100) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, INDX
, HASH
, ADDRESS
, CACHE#
, CACHE_NAME
, EXISTENT
, LOCK_MODE
, LOCK_REQUEST
, TXN
, SADDR
, INST_LOCK_REQUEST
, INST_LOCK_RELEASE
, INST_LOCK_TYPE
, INST_LOCK_ID1
, INST_LOCK_ID2
, KEY
, CON_ID
FROM SYS.GV_$ROWCACHE_PARENT;
|
|
|