VIEW: SYS.USER_ILMTASKS

Source

View Text - Preformatted

SELECT a.execution_id,
       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
 WHERE a.owner = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT A.EXECUTION_ID
, 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
WHERE A.OWNER = USERENV('SCHEMAID')