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')