1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: DBA_HIST_LATCH to DBA_STORED_SETTINGS
  4. DBA_ILMTASKS

5.102 DBA_ILMTASKS

DBA_ILMTASKS displays information on Automatic Data Optimization execution.

Related View

USER_ILMTASKS displays information on Automatic Data Optimization tasks created by a user.

Note:

Automatic Data Optimization is supported in multitenant environments starting with Oracle Database 12c Release 2 (12.2.0.1).

Column Datatype NULL Description

TASK_ID

NUMBER

Number that uniquely identifies a specific Automatic Data Optimization task

TASK_OWNER

VARCHAR2(128)

NOT NULL

User who initiates the task

STATE

VARCHAR2(9)

Possible values:

  • INACTIVE: Indicates that the task was created for previewing

  • ACTIVE: Indicates that jobs have been created for the qualifying policies in the task

  • COMPLETE: Indicates that the task has completed

CREATION_TIME

TIMESTAMP(6)

The time that the task was created

START_TIME

TIMESTAMP(6)

Start time of a specific task

COMPLETION_TIME

TIMESTAMP(6)

Completion time of a specific task

See Also:

"USER_ILMTASKS"