2014 OTN APAC Tour #NZOUG14 Testing ADO Policies: Forcing ILM Evaluation DECLARE tid NUMBER; BEGIN DBMS_ILM.EXECUTE_ILM(owner => AP , object_name => ROLLON_PARTED , task_id => tid); DBMS_ILM.EXECUTE_ILM(owner => AP', object_name => RANDOMIZED_PARTED ,task_id => tid); END; / ` Now, all we have to do to is wait for the database's nightly maintenance task cycle to complete … ILM Objects Most Recently Evaluated (from DBA_ILMEVALUATIONDETAILS) Task ILM Object Subobject ID Policy Owner Object Name Name Object Type Reason Chosen Job Name ----- ------ ------ -------------------- ---------- --------------- ------------------------------ ---------- 2905 P150 AP RANDOMIZED_PARTED P4_COLD TABLE PARTITION SELECTED FOR EXECUTION ILMJOB582 2905 P149 AP RANDOMIZED_PARTED P3_COOL TABLE PARTITION SELECTED FOR EXECUTION ILMJOB580 2905 P147 AP RANDOMIZED_PARTED P1_HOT TABLE PARTITION SELECTED FOR EXECUTION ILMJOB576 2905 P148 AP RANDOMIZED_PARTED P2_WARM TABLE PARTITION SELECTED FOR EXECUTION ILMJOB578 2895 P146 AP ROLLON_PARTED TABLE POLICY DISABLED.....
{}