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