GV$FILE_CACHE_TRANSFER definition in Oracle 9i / www.oracledba.ru
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