GV$FILE_CACHE_TRANSFER definition in Oracle Database 11.2
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