Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E25513-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$QMON_COORDINATOR_STATS

V$QMON_COORDINATOR_STATS displays information and statistics about the Queue Monitor Coordinator process (QMNC). There is one row per instance. The rows are deleted when the database (or instance in an Oracle RAC environment) restarts.

Column Datatype Description
QMNC_PID VARCHAR2(24) Queue Monitor Coordinator process ID
STATUS VARCHAR2(24) Current status of the coordinator:
  • DEAD

  • INITIALIZING

  • RUNNING TASK COORDINATOR

  • WAITING

  • ADDING SERVER

NUM_SERVERS NUMBER Number of QMON servers currently running
LAST_SERVER_START_TIME TIMESTAMP(3) WITH TIME ZONE Last server startup time
LAST_SERVER_PID VARCHAR2(24) Process ID of the last server process (Qnnn) created
NEXT_WAKEUP_TIME TIMESTAMP(3) WITH TIME ZONE Next wakeup time of the coordinator
NEXT_READY_TIME TIMESTAMP(3) WITH TIME ZONE Ready time of the first delayed task
NEXT_EXPIRY_TIME TIMESTAMP(3) WITH TIME ZONE Expiry time of the next ready task
LAST_WAIT_TIME TIMESTAMP(3) WITH TIME ZONE Time when the coordinator went to sleep
LAST_FAILURE VARCHAR2(32) Last failure encountered
LAST_FAILURE_TIME TIMESTAMP(3) WITH TIME ZONE Last failure time
MAX_TASK_LATENCY VARCHAR2(40) Maximum task latency across all the servers (in seconds)
MIN_TASK_LATENCY VARCHAR2(40) Minimum task latency across all the servers (in seconds)
TOTAL_TASK_LATENCY NUMBER Cumulative latency across all the tasks (in seconds)
TOTAL_TASKS_EXECUTED NUMBER Cumulative number of tasks serviced by all the servers
MAX_SERVERS NUMBER Maximum number of servers present at any point of time