VIEW: SYS.DBA_ILMTASKS

Source

View Text - Preformatted

SELECT a.execution_id, b.name,
       DECODE(a.execution_state, 1, 'INACTIVE',
                                 2, 'ACTIVE',
                                 3, 'COMPLETED',
                                 'UNKNOWN'),
       a.creation_time,
       a.start_time,
       a.completion_time
  FROM sys.ilm_execution$ a, sys.user$ b
 where a.owner = b.user#

View Text - HTML Formatted

SELECT A.EXECUTION_ID
, B.NAME
, DECODE(A.EXECUTION_STATE
, 1
, 'INACTIVE'
, 2
, 'ACTIVE'
, 3
, 'COMPLETED'
, 'UNKNOWN')
, A.CREATION_TIME
, A.START_TIME
, A.COMPLETION_TIME
FROM SYS.ILM_EXECUTION$ A
, SYS.USER$ B
WHERE A.OWNER = B.USER#