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

E17615-23
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_TASKS

V$QMON_TASKS displays information and statistics about all queue background tasks in the system, which would be served by queue monitor servers. There is one row per task. The rows are deleted when the database (or instance in an Oracle RAC environment) restarts.

Column Datatype Description
TASK_NAME VARCHAR2(32) Task name
TASK_NUMBER NUMBER Unique task number
TASK_TYPE VARCHAR2(40) Task type
TASK_SUBMIT_TIME TIMESTAMP(3) WITH TIME ZONE Task submit time
TASK_READY_TIME TIMESTAMP(3) WITH TIME ZONE Task ready time
TASK_EXPIRY_TIME TIMESTAMP(3) WITH TIME ZONE Time when this task expires
TASK_START_TIME TIMESTAMP(3) WITH TIME ZONE Last actual start time for the task
TASK_STATUS VARCHAR2(32) Status of the task
SERVER_NAME VARCHAR2(48) Name of the QMON server running this task
MAX_RETRIES NUMBER Maximum retry count for the task
NUM_RUNS NUMBER Number of runs of the task if repeatable
NUM_FAILURES NUMBER Number of failures encountered while running 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.