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