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