GV$TEMP_CACHE_TRANSFER definition in Oracle Database 10.2 / www.oracledba.ru
GV$TEMP_CACHE_TRANSFER
select
x.inst_id, -- INST_ID NUMBER
kcftiofno, -- FILE_NUMBER NUMBER
0, -- X_2_NULL NUMBER
0, -- X_2_NULL_FORCED_WRITE NUMBER
0, -- X_2_NULL_FORCED_STALE NUMBER
0, -- X_2_S NUMBER
0, -- X_2_S_FORCED_WRITE NUMBER
0, -- S_2_NULL NUMBER
0, -- S_2_NULL_FORCED_STALE NUMBER
0, -- RBR NUMBER
0, -- RBR_FORCED_WRITE NUMBER
0, -- NULL_2_X NUMBER
0, -- S_2_X NUMBER
0 -- NULL_2_S NUMBER
from
x$kcftio x,
x$kcctf tf
where
x.kcftiofno = tf.tfnum