GV$PQ_TQSTAT

select
inst_id,                 -- INST_ID NUMBER
kxfqsqn,                 -- DFO_NUMBER NUMBER
kxfqsid,                 -- TQ_ID NUMBER
rpad (kxfqsty, 10),      -- SERVER_TYPE VARCHAR2(10)
kxfqscnt,                -- NUM_ROWS NUMBER
kxfqslen,                -- BYTES NUMBER
kxfqset,                 -- OPEN_TIME NUMBER
kxfqsavl,                -- AVG_LATENCY NUMBER
kxfqsdw,                 -- WAITS NUMBER
kxfqsdt,                 -- TIMEOUTS NUMBER
rpad (kxfqssid, 10),     -- PROCESS VARCHAR2(10)
kxfqsiid                 -- INSTANCE NUMBER
from
x$kxfqsrow
home |  up  |  mailbox