DBA Data[Home] [Help] [Dependency Information]


VIEW: SYS.V_$QMON_TASKS

Object Details
Object Name: V_$QMON_TASKS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
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

Query Text

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;

Dependencies

[top of page]

SYS.V_$QMON_TASKS references the following:

SYS.V_$QMON_TASKS is referenced by following:

SchemaPUBLIC
SynonymV$QMON_TASKS