V$QMON_COORDINATOR_STATS definition in Oracle Database 11.2
V$QMON_COORDINATOR_STATS

select
  QMNC_PID,                                -- QMNC_PID VARCHAR2(24)
  STATUS,                                  -- STATUS VARCHAR2(24)
  NUM_SERVERS,                             -- NUM_SERVERS NUMBER
  LAST_SERVER_START_TIME,                  -- LAST_SERVER_START_TIME TIMESTAMP(3) WITH TIME ZONE
  LAST_SERVER_PID,                         -- LAST_SERVER_PID VARCHAR2(24)
  NEXT_WAKEUP_TIME,                        -- NEXT_WAKEUP_TIME TIMESTAMP(3) WITH TIME ZONE
  NEXT_READY_TIME,                         -- NEXT_READY_TIME TIMESTAMP(3) WITH TIME ZONE
  NEXT_EXPIRY_TIME,                        -- NEXT_EXPIRY_TIME TIMESTAMP(3) WITH TIME ZONE
  LAST_WAIT_TIME,                          -- LAST_WAIT_TIME TIMESTAMP(3) WITH TIME ZONE
  LAST_FAILURE,                            -- LAST_FAILURE VARCHAR2(32)
  LAST_FAILURE_TIME,                       -- LAST_FAILURE_TIME TIMESTAMP(3) WITH TIME ZONE
  MAX_TASK_LATENCY,                        -- MAX_TASK_LATENCY VARCHAR2(40)
  MIN_TASK_LATENCY,                        -- MIN_TASK_LATENCY VARCHAR2(40)
  TOTAL_TASK_LATENCY,                      -- TOTAL_TASK_LATENCY NUMBER
  TOTAL_TASKS_EXECUTED,                    -- TOTAL_TASKS_EXECUTED NUMBER
  MAX_SERVERS                              -- MAX_SERVERS NUMBER
from
  GV$QMON_COORDINATOR_STATS
where
  INST_ID = USERENV('Instance')

home |  up