DBA Data[Home] [Help]

VIEW: SYS.V_$ROWCACHE_PARENT

Source

View Text - Preformatted

select "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 v$rowcache_parent
View Text - HTML Formatted

SELECT "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 V$ROWCACHE_PARENT