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 |