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

E17615-24
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_ILMRESULTS

DBA_ILMRESULTS displays information on data movement-related Automatic Data Optimization jobs in the database.

Related View

USER_ILMRESULTS displays information on data movement-related Automatic Data Optimization jobs for tasks created by the 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
JOB_NAME VARCHAR2(128)   Name of the Automatic Data Optimization job
JOB_STATE VARCHAR2(31)   State of the job. Possible values:
  • JOB CREATED

  • COMPLETED SUCCESSFULLY

  • FAILED

  • STOPPED

  • JOB CREATION FAILED

  • DEPENDENT OBJECTS BEING REBUILT

  • FAILED TO REBUILD DEPENDENT OBJECTS

START_TIME TIMESTAMP(6)   Start time of the Automatic Data Optimization job
COMPLETION_TIME TIMESTAMP(6)   Completion time of the Automatic Data Optimization job
COMMENTS VARCHAR2(300)   Additional information in cases where the Automatic Data Optimization job execution fails
STATISTICS CLOB   Job specific statistics, such as space saved via compression. This column is in the form of comma separated name / value pairs, with each pair representing a particular statistic name and value.