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

home |  up  |  mailbox