GV$FILE_CACHE_TRANSFER
select x.inst_id, -- INST_ID NUMBER kcfiofno, -- FILE_NUMBER NUMBER KCFIOX2NC, -- X_2_NULL NUMBER KCFIOX2NFWC, -- X_2_NULL_FORCED_WRITE NUMBER KCFIOX2NFSC, -- X_2_NULL_FORCED_STALE NUMBER KCFIOX2SC, -- X_2_S NUMBER KCFIOX2SFWC, -- X_2_S_FORCED_WRITE NUMBER KCFIOS2NC, -- S_2_NULL NUMBER KCFIOS2NFSC, -- S_2_NULL_FORCED_STALE NUMBER KCFIORBRC, -- RBR NUMBER KCFIORBRFWC, -- RBR_FORCED_WRITE NUMBER KCFIORBRFSC, -- RBR_FORCED_STALE NUMBER KCFION2XC, -- NULL_2_X NUMBER KCFIOS2XC, -- S_2_X NUMBER KCFION2SC, -- NULL_2_S NUMBER KCFIOCRTR, -- CR_TRANSFERS NUMBER KCFIOCURTR -- CUR_TRANSFERS NUMBER from x$kcfio x, x$kccfe fe where x.kcfiofno = fe.fenum

home |  up  |  mailbox