DBA Data[Home] [Help]

VIEW: SYS.V_$TEMP_CACHE_TRANSFER

Source

View Text - Preformatted

select "FILE_NUMBER","X_2_NULL","X_2_NULL_FORCED_WRITE","X_2_NULL_FORCED_STALE","X_2_S","X_2_S_FORCED_WRITE","S_2_NULL","S_2_NULL_FORCED_STALE","RBR","RBR_FORCED_WRITE","NULL_2_X","S_2_X","NULL_2_S","CON_ID" from v$temp_cache_transfer
View Text - HTML Formatted

SELECT "FILE_NUMBER"
, "X_2_NULL"
, "X_2_NULL_FORCED_WRITE"
, "X_2_NULL_FORCED_STALE"
, "X_2_S"
, "X_2_S_FORCED_WRITE"
, "S_2_NULL"
, "S_2_NULL_FORCED_STALE"
, "RBR"
, "RBR_FORCED_WRITE"
, "NULL_2_X"
, "S_2_X"
, "NULL_2_S"
, "CON_ID"
FROM V$TEMP_CACHE_TRANSFER