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