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