GV$SEGSTAT_NAME

select
inst_id,                 -- INST_ID NUMBER
st_statid,               -- STATISTIC# NUMBER
st_name,                 -- NAME VARCHAR2(64)
decode                   -- SAMPLED VARCHAR2(3)
  (bitand (st_flag, 1), 0, 'NO', 1, 'YES') 
from
x$ksolsstat 
where
bitand (st_flag, 2) <> 2
home |  up  |  mailbox