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

E41527-09
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_ILMEVALUATIONDETAILS

DBA_ILMEVALUATIONDETAILS displays details on evaluation of Automatic Data Optimization policies considered for Automatic Data Optimization tasks. It also shows the job name that executes the policy, in case the policy was selected for execution. If the policy was not selected for execution, this view provides a reason.

Related View

USER_ILMEVALUATIONDETAILS displays details on evaluation of Automatic Data Optimization policies considered for Automatic Data Optimization tasks for a user. It also shows the job name that executes the policy, in case the policy was selected for execution. If the policy was not selected for execution, this view provides a reason.

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
POLICY_NAME VARCHAR2(128) NOT NULL Name of the Automatic Data Optimization policy
OBJECT_OWNER VARCHAR2(128) NOT NULL Owner of the object associated with the Automatic Data Optimization policy
OBJECT_NAME VARCHAR2(128) NOT NULL Name of the object associated with the Automatic Data Optimization policy
SUBOBJECT_NAME VARCHAR2(128)   Name of the subobject associated with the Automatic Data Optimization policy
OBJECT_TYPE VARCHAR2(18)   Object type. Valid values include TABLE, TABLE PARTITION, and TABLE SUBPARTITION.
SELECTED_FOR_EXECUTION VARCHAR2(42)   Indicates whether the policy has been selected for execution on the object. If not, the reason for not being selected is listed. Possible values:
  • POLICY DISABLED

  • SELECTED FOR EXECUTION

  • POLICY OVERRULED

  • INHERITED POLICY OVERRULED

  • PRECONDITION NOT SATISFIED

  • JOB ALREADY EXISTS

  • NO OPERATION SINCE LAST ILM ACTION

  • TABLE HAS MATERIALIZED VIEW

  • TARGET COMPRESSION NOT HIGHER THAN CURRENT

  • STATISTICS NOT AVAILABLE

The value SELECTED FOR EXECUTION means a job was created for this policy on the object. The other values state the reason why the policy on the object was selected for execution.

JOB_NAME VARCHAR2(128)   Name of the job in the case where the policy is selected for execution on this object
COMMENTS VARCHAR2(4000)   Reserved for future use