GV$QMON_TASK_STATS definition in Oracle Database 11.2
GV$QMON_TASK_STATS

select
  INST_ID,                                 -- INST_ID NUMBER
  TASKNAME_KWQMNCTID,                      -- TASK_NAME VARCHAR2(32)
  decode (                                 -- TASK_TYPE VARCHAR2(40)
    TASKTYPE_KWQMNCTID, 0, 'REPEATABLE_MULTIPLE', 1, 'REPEATABLE_SINGLE', 2, 'NONREPEATABLE_MULTIPLE', 3, 'NONREPEATABLE_SINGLE', 4, 'UNKNOWN', TASKTYPE_KWQMNCTID),
  LASTCRTTSKNUM_KWQMNCTID,                 -- LAST_CREATED_TASKNUM NUMBER
  TOTAL_TASK_KWQMNCTID,                    -- NUM_TASKS NUMBER
  TOTAL_RUNTIME_KWQMNCTID,                 -- TOTAL_TASK_RUN_TIME NUMBER
  TOTAL_RUNS_KWQMNCTID,                    -- TOTAL_TASK_RUNS NUMBER
  TOTAL_FAILURES_KWQMNCTID,                -- TOTAL_TASK_FAILURES NUMBER
  METRICNAME_KWQMNCTID,                    -- METRIC_TYPE VARCHAR2(50)
  METRICVAL_KWQMNCTID,                     -- METRIC_VALUE NUMBER
  LASTFAILURE_KWQMNCTID,                   -- LAST_FAILURE VARCHAR2(32)
  LASTFAILTIM_KWQMNCTID,                   -- LAST_FAILURE_TIME TIMESTAMP(3) WITH TIME ZONE
  LASTFAILTSKNUM_KWQMNCTID,                -- LAST_FAILURE_TASKNUM NUMBER
  REMARK_KWQMNCTID                         -- REMARK VARCHAR2(64)
from
  X$KWQMNTASKSTAT

home |  up