Hi all
I successfully activated ILM policies with
alter table TABLE_A ILM ADD POLICY COLUMN STORE COMPRESS FOR QUERY HIGH SEGMENT AFTER 2 DAYS OF NO MODIFICATION;
(2 days for testing purposes).
The policies work fine for recent partitions. When checking overall compression after a bit over a week, I saw that many older partitions are not compressed yet.
Digging in DBA_ILMEVALUATIONDETAILS, I see that the objects are selected for execution:
| 242 | P134 | OWNER_NAME | TABLE_A | SYS_P3341 | TABLE PARTITION | SELECTED FOR EXECUTION | ILMJOB21354 | |
With the JOB_NAME, I check in DBA_ILMRESULTS and find the following entry:
| TASK_ID | JOB_NAME | JOB_STATE | START_TIME | COMPLETION_TIME | COMMENTS | STATISTICS |
| 242 | ILMJOB21354 | STOPPED | | | Job creation stopped by ADO framework | |
So now I'm stuck. How can I find out, why the job was stopped?
If I run DBMS_ILM.EXECUTE_ILM manually for this partition, the job runs fine and the partition is compressed afterwards.