select
DFO_NUMBER, -- DFO_NUMBER NUMBER
TQ_ID, -- TQ_ID NUMBER
SERVER_TYPE, -- SERVER_TYPE VARCHAR2(10)
NUM_ROWS, -- NUM_ROWS NUMBER
BYTES, -- BYTES NUMBER
OPEN_TIME, -- OPEN_TIME NUMBER
AVG_LATENCY, -- AVG_LATENCY NUMBER
WAITS, -- WAITS NUMBER
TIMEOUTS, -- TIMEOUTS NUMBER
PROCESS, -- PROCESS VARCHAR2(10)
INSTANCE -- INSTANCE NUMBER
from
GV$PQ_TQSTAT
where
inst_id = USERENV('Instance')