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')