[Home] [Help] [Dependency Information]
Object Name: | V_$QMON_TASKS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TASK_NAME | VARCHAR2 | (32) | ||
TASK_NUMBER | NUMBER | |||
TASK_TYPE | VARCHAR2 | (40) | ||
TASK_SUBMIT_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
TASK_READY_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
TASK_EXPIRY_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
TASK_START_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
TASK_STATUS | VARCHAR2 | (32) | ||
SERVER_NAME | VARCHAR2 | (48) | ||
MAX_RETRIES | NUMBER | |||
NUM_RUNS | NUMBER | |||
NUM_FAILURES | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TASK_NAME
, TASK_NUMBER
, TASK_TYPE
, TASK_SUBMIT_TIME
, TASK_READY_TIME
, TASK_EXPIRY_TIME
, TASK_START_TIME
, TASK_STATUS
, SERVER_NAME
, MAX_RETRIES
, NUM_RUNS
, NUM_FAILURES
, CON_ID
FROM SYS.V_$QMON_TASKS;
|
|
|