GV$FILE_CACHE_TRANSFER

select
x.inst_id,               -- INST_ID NUMBER
kcfiofno,                -- FILE_NUMBER 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,                       -- S_2_NULL NUMBER
0,                       -- S_2_NULL_FORCED_STALE NUMBER
0,                       -- RBR NUMBER
0,                       -- RBR_FORCED_WRITE NUMBER
0,                       -- RBR_FORCED_STALE NUMBER
0,                       -- NULL_2_X NUMBER
0,                       -- S_2_X NUMBER
0,                       -- NULL_2_S NUMBER
0,                       -- CR_TRANSFERS NUMBER
0                        -- CUR_TRANSFERS NUMBER
from
x$kcfio x,
x$kccfe fe 
where
x.kcfiofno = fe.fenum
home |  up  |  mailbox