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

home |  up  |  mailbox