V$QMON_TASK_STATS

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
TOTAL_TASK_FAILURES NUMBER Cumulative failures
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