GV$ENQUEUE_STAT

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