GV$SESSTAT
select inst_id, -- INST_ID NUMBER indx, -- SID NUMBER ksusestn, -- STATISTIC# NUMBER ksusestv -- VALUE NUMBER from x$ksusesta where bitand (ksspaflg, 1) !=0 and bitand (ksuseflg, 1) !=0 and ksusestn< ( select count (*) from x$ksusd)

home |  up  |  mailbox