GV$ENQUEUE_STATISTICS

select
st.inst_id,              -- INST_ID NUMBER
eqt.name,                -- EQ_NAME VARCHAR2(64)
st.ksqsttyp,             -- EQ_TYPE VARCHAR2(2)
st.ksqstrsn,             -- REQ_REASON VARCHAR2(64)
st.ksqstreq,             -- TOTAL_REQ# NUMBER
st.ksqstwat,             -- TOTAL_WAIT# NUMBER
st.ksqstsgt,             -- SUCC_REQ# NUMBER
st.ksqstfgt,             -- FAILED_REQ# NUMBER
st.ksqstwtm,             -- CUM_WAIT_TIME NUMBER
st.ksqstexpl,            -- REQ_DESCRIPTION VARCHAR2(4000)
st.ksqstevidx            -- EVENT# NUMBER
from
X$KSQST st,
X$KSQEQTYP eqt 
where
(st.inst_id = eqt.inst_id) and (st.ksqsttyp = eqt.resname) and (st.indx > 0)
home |  up  |  mailbox