V$QMON_SERVER_STATS definition in Oracle Database 11.2
V$QMON_SERVER_STATS

select
  QMNC_PID,                                -- QMNC_PID VARCHAR2(24)
  SERVER_PID,                              -- SERVER_PID VARCHAR2(24)
  SERVER_NAME,                             -- SERVER_NAME VARCHAR2(64)
  STATUS,                                  -- STATUS VARCHAR2(40)
  SERVER_START_TIME,                       -- SERVER_START_TIME TIMESTAMP(3) WITH TIME ZONE
  TASK_NAME,                               -- TASK_NAME VARCHAR2(32)
  TASK_NUMBER,                             -- TASK_NUMBER NUMBER
  TASK_START_TIME,                         -- TASK_START_TIME TIMESTAMP(3) WITH TIME ZONE
  LAST_WAIT_TIME,                          -- LAST_WAIT_TIME TIMESTAMP(3) WITH TIME ZONE
  MAX_LATENCY,                             -- MAX_LATENCY NUMBER
  MIN_LATENCY,                             -- MIN_LATENCY NUMBER
  TOTAL_LATENCY,                           -- TOTAL_LATENCY NUMBER
  NUM_TASKS,                               -- NUM_TASKS NUMBER
  LAST_FAILURE,                            -- LAST_FAILURE VARCHAR2(32)
  LAST_FAILURE_TIME,                       -- LAST_FAILURE_TIME TIMESTAMP(3) WITH TIME ZONE
  LAST_FAILURE_TASK,                       -- LAST_FAILURE_TASK VARCHAR2(32)
  LAST_FAILURE_TASKNUM                     -- LAST_FAILURE_TASKNUM NUMBER
from
  GV$QMON_SERVER_STATS
where
  INST_ID = USERENV('Instance')

home |  up