[Home] [Help]
select "FILE#","BLOCK#","CLASS#","STATUS","XNC","FORCED_READS","FORCED_WRITES","NAME","PARTITION_NAME","KIND","OWNER#","LOCK_ELEMENT_ADDR","LOCK_ELEMENT_NAME","CON_ID" from v$cache_transfer
SELECT "FILE#"
, "BLOCK#"
, "CLASS#"
, "STATUS"
, "XNC"
, "FORCED_READS"
, "FORCED_WRITES"
, "NAME"
, "PARTITION_NAME"
, "KIND"
, "OWNER#"
, "LOCK_ELEMENT_ADDR"
, "LOCK_ELEMENT_NAME"
, "CON_ID"
FROM V$CACHE_TRANSFER
|
|
|
|