select
  TASK_NAME,                               -- TASK_NAME VARCHAR2(32)
  TASK_TYPE,                               -- TASK_TYPE VARCHAR2(40)
  LAST_CREATED_TASKNUM,                    -- LAST_CREATED_TASKNUM NUMBER
  NUM_TASKS,                               -- NUM_TASKS NUMBER
  TOTAL_TASK_RUN_TIME,                     -- TOTAL_TASK_RUN_TIME NUMBER
  TOTAL_TASK_RUNS,                         -- TOTAL_TASK_RUNS NUMBER
  TOTAL_TASK_FAILURES,                     -- TOTAL_TASK_FAILURES NUMBER
  METRIC_TYPE,                             -- METRIC_TYPE VARCHAR2(50)
  METRIC_VALUE,                            -- METRIC_VALUE NUMBER
  LAST_FAILURE,                            -- LAST_FAILURE VARCHAR2(32)
  LAST_FAILURE_TIME,                       -- LAST_FAILURE_TIME TIMESTAMP(3) WITH TIME ZONE
  LAST_FAILURE_TASKNUM,                    -- LAST_FAILURE_TASKNUM NUMBER
  REMARK                                   -- REMARK VARCHAR2(64)
from
  GV$QMON_TASK_STATS
where
  INST_ID = USERENV('Instance')