Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

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


V$QMON_TASK_STATS displays information and statistics based on different queue monitor tasks in the system (spilling, time manager activity, and so on). There is one row per kind of task. The rows are deleted when the database (or instance in an Oracle RAC environment) restarts.

Column Datatype Description
TASK_NAME VARCHAR2(32) Name of the task
TASK_TYPE VARCHAR2(40) Type of the task
LAST_CREATED_TASKNUM NUMBER Unique task number last created for this task
NUM_TASKS NUMBER Number of tasks currently present
TOTAL_TASK_RUN_TIME NUMBER Cumulative task run time
TOTAL_TASK_RUNS NUMBER Cumulative task runs
METRIC_TYPE VARCHAR2(50) Type of metric gathered for this task type
METRIC_VALUE NUMBER Value of this metric
LAST_FAILURE VARCHAR2(32) Last failure encountered while executing this type of task
LAST_FAILURE_TIME TIMESTAMP(3) WITH TIME ZONE Time when the last failure occurred
LAST_FAILURE_TASKNUM NUMBER Task number of the last failed task for this task
REMARK VARCHAR2(64) Remarks about the 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.