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