GV$TEMP_CACHE_TRANSFER definition in Oracle 9i / www.oracledba.ru
GV$TEMP_CACHE_TRANSFER
select
x.inst_id, -- INST_ID NUMBER
kcftiofno, -- FILE_NUMBER NUMBER
KCFTIOX2NC, -- X_2_NULL NUMBER
KCFTIOX2NFWC, -- X_2_NULL_FORCED_WRITE NUMBER
KCFTIOX2NFSC, -- X_2_NULL_FORCED_STALE NUMBER
KCFTIOX2SC, -- X_2_S NUMBER
KCFTIOX2SFWC, -- X_2_S_FORCED_WRITE NUMBER
KCFTIOS2NC, -- S_2_NULL NUMBER
KCFTIOS2NFSC, -- S_2_NULL_FORCED_STALE NUMBER
KCFTIORBRC, -- RBR NUMBER
KCFTIORBRFWC, -- RBR_FORCED_WRITE NUMBER
KCFTION2XC, -- NULL_2_X NUMBER
KCFTIOS2XC, -- S_2_X NUMBER
KCFTION2SC -- NULL_2_S NUMBER
from
x$kcftio x,
x$kcctf tf
where
x.kcftiofno = tf.tfnum