GV$ENQUEUE_STAT

select
inst_id,                 -- INST_ID NUMBER
ksqsttyp,                -- EQ_TYPE VARCHAR2(2)
sum (ksqstreq),          -- TOTAL_REQ# NUMBER
sum (ksqstwat),          -- TOTAL_WAIT# NUMBER
sum (ksqstsgt),          -- SUCC_REQ# NUMBER
sum (ksqstfgt),          -- FAILED_REQ# NUMBER
sum (ksqstwtm)           -- CUM_WAIT_TIME NUMBER
from
X$KSQST 
group by inst_id,
ksqsttyp 
having sum (ksqstreq) > 0
home |  up  |  mailbox