GV$PQ_TQSTAT definition in Oracle Database 11.2
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