GV$TEMP_PING
select x.inst_id, -- INST_ID NUMBER kcftiofno, -- FILE_NUMBER NUMBER 0, -- FREQUENCY 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 0, -- X_2_SSX NUMBER 0, -- X_2_SSX_FORCED_WRITE NUMBER KCFTIOS2NC, -- S_2_NULL NUMBER KCFTIOS2NFSC, -- S_2_NULL_FORCED_STALE NUMBER 0, -- SS_2_NULL NUMBER 0, -- SS_2_RLS NUMBER 0, -- WRB NUMBER 0, -- WRB_FORCED_WRITE NUMBER KCFTIORBRC, -- RBR NUMBER KCFTIORBRFWC, -- RBR_FORCED_WRITE NUMBER 0, -- RBR_FORCED_STALE NUMBER 0, -- CBR NUMBER 0, -- CBR_FORCED_WRITE NUMBER KCFTION2XC, -- NULL_2_X NUMBER KCFTIOS2XC, -- S_2_X NUMBER 0, -- SSX_2_X NUMBER KCFTION2SC, -- NULL_2_S NUMBER 0, -- NULL_2_SS NUMBER 0 -- OP_2_SS NUMBER from x$kcftio x, x$kcctf tf where x.kcftiofno = tf.tfnum

home |  up  |  mailbox