V$QMON_TASKS definition in Oracle Database 11.2
V$QMON_TASKS

select
  TASK_NAME,                               -- TASK_NAME VARCHAR2(32)
  TASK_NUMBER,                             -- TASK_NUMBER NUMBER
  TASK_TYPE,                               -- TASK_TYPE VARCHAR2(40)
  TASK_SUBMIT_TIME,                        -- TASK_SUBMIT_TIME TIMESTAMP(3) WITH TIME ZONE
  TASK_READY_TIME,                         -- TASK_READY_TIME TIMESTAMP(3) WITH TIME ZONE
  TASK_EXPIRY_TIME,                        -- TASK_EXPIRY_TIME TIMESTAMP(3) WITH TIME ZONE
  TASK_START_TIME,                         -- TASK_START_TIME TIMESTAMP(3) WITH TIME ZONE
  TASK_STATUS,                             -- TASK_STATUS VARCHAR2(32)
  SERVER_NAME,                             -- SERVER_NAME VARCHAR2(64)
  MAX_RETRIES,                             -- MAX_RETRIES NUMBER
  NUM_RUNS,                                -- NUM_RUNS NUMBER
  NUM_FAILURES                             -- NUM_FAILURES NUMBER
from
  GV$QMON_TASKS
where
  INST_ID = USERENV('Instance')

home |  up