V$PQ_TQSTAT definition in Oracle Database 11.2
V$PQ_TQSTAT

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

home |  up