PDL Auto Deletion not working at configured period
Created index on modifications_attributes to allow for quick deletes. Command for this is:
cmd> set ORACLE_SID=ADVA
cmd> sqlplus ops$ocshis/ocshis
sqlplus> CREATE INDEX ops$ocshis.MODIFICATIONS_ATTRIBUTES_INDX ON ops$ocshis.MODIFICATIONS_ATTRIBUTES
(TASKID) INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 1M NEXT 1M) PCTFREE 10 TABLESPACE HS_IPDL;
Note: cmd> and sqlplus> represent the command prompt and are not entered. The synatx of the create is important. So you might want to copy it to a txt document and to the IM where it can be copied into the cmd prompt.
After index is created, deletes take seconds and the other problems with reset of delete date is not seen if IM restarted.