GV$FILE_PING
select x.inst_id, -- INST_ID NUMBER kcfiofno, -- FILE_NUMBER NUMBER 0, -- FREQUENCY 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, -- X_2_SSX NUMBER 0, -- X_2_SSX_FORCED_WRITE NUMBER 0, -- S_2_NULL NUMBER 0, -- S_2_NULL_FORCED_STALE NUMBER 0, -- SS_2_NULL NUMBER 0, -- SS_2_RLS NUMBER 0, -- WRB NUMBER 0, -- WRB_FORCED_WRITE NUMBER 0, -- RBR NUMBER 0, -- RBR_FORCED_WRITE NUMBER 0, -- RBR_FORCED_STALE NUMBER 0, -- CBR NUMBER 0, -- CBR_FORCED_WRITE NUMBER 0, -- NULL_2_X NUMBER 0, -- S_2_X NUMBER 0, -- SSX_2_X NUMBER 0, -- NULL_2_S NUMBER 0, -- NULL_2_SS NUMBER 0 -- OP_2_SS NUMBER from x$kcfio x, x$kccfe fe where x.kcfiofno = fe.fenum

home |  up  |  mailbox