8.147 V$QMON_SERVER_STATS

V$QMON_SERVER_STATS displays information and statistics about the active queue monitor server processes. There is one row per live queue monitor server process. The rows are deleted when the database (or instance in an Oracle RAC environment) restarts.
Column Datatype Description

QMNC_PID

VARCHAR2(24)

Non-sharded queue master process ID

SERVER_PID

VARCHAR2(24)

Process ID of the server

SERVER_NAME

VARCHAR2(48)

Name of the server

STATUS

VARCHAR2(40)

Current state of the server:

  • UNUSED

  • RUNNING

  • IDLE WAIT

  • EXITING

  • NOT ACTIVE

SERVER_START_TIME

TIMESTAMP(3) WITH TIME ZONE

Start time of the server

TASK_NAME

VARCHAR2(32)

Current executing task

TASK_NUMBER

NUMBER

Unique task number of the running task

TASK_START_TIME

TIMESTAMP(3) WITH TIME ZONE

Start time of the running task

LAST_WAIT_TIME

TIMESTAMP(3) WITH TIME ZONE

Time when the server last waited

MAX_LATENCY

NUMBER

Maximum task latency for this server (in seconds)

MIN_LATENCY

NUMBER

Minimum task latency for this server (in seconds)

TOTAL_LATENCY

NUMBER

Cumulative task latency for this server (in seconds)

NUM_TASKS

NUMBER

Number of tasks processed by the server

LAST_FAILURE

VARCHAR2(128)

Last failure encountered by the server

LAST_FAILURE_TIME

TIMESTAMP(3) WITH TIME ZONE

Last failure time

LAST_FAILURE_TASK

VARCHAR2(32)

Task being run at the time of the last failure

LAST_FAILURE_TASKNUM

NUMBER

Unique task number of the failed task

CON_ID

NUMBER

The ID of the container to which the data pertains. The CON_ID value in this view is always 0. The rows pertain to the entire CDB or to the non-CDB.