Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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 not supported with a CDB.
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"