GV$FILE_PING

select
x.inst_id,               -- INST_ID NUMBER
kcfiofno,                -- FILE_NUMBER NUMBER
0,                       -- FREQUENCY 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
0,                       -- X_2_SSX NUMBER
0,                       -- X_2_SSX_FORCED_WRITE NUMBER
KCFIOS2NC,               -- S_2_NULL NUMBER
KCFIOS2NFSC,             -- S_2_NULL_FORCED_STALE NUMBER
0,                       -- SS_2_NULL NUMBER
0,                       -- SS_2_RLS NUMBER
0,                       -- WRB NUMBER
0,                       -- WRB_FORCED_WRITE NUMBER
KCFIORBRC,               -- RBR NUMBER
KCFIORBRFWC,             -- RBR_FORCED_WRITE NUMBER
KCFIORBRFSC,             -- RBR_FORCED_STALE NUMBER
0,                       -- CBR NUMBER
0,                       -- CBR_FORCED_WRITE NUMBER
KCFION2XC,               -- NULL_2_X NUMBER
KCFIOS2XC,               -- S_2_X NUMBER
0,                       -- SSX_2_X NUMBER
KCFION2SC,               -- 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  |  mailbox