GV$TEMP_PING

select
x.inst_id,               -- INST_ID NUMBER
kcftiofno,               -- 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$kcftio x,
x$kcctf tf 
where
x.kcftiofno = tf.tfnum
home |  up  |  mailbox