24x7 ATP Plan Run Not Removing All Demands Originating From ATP (Doc ID 2151534.1)
We are experiencing this issue in our 12.1.3.9.2 VCP environment, but only in DEV. It doesn't seem to happen in prod.
We have noticed this in the QA and DEV4 environments that we have that are capable of running plans and data collections. That ATP Post Plan Processing job seems to run for a very long time.
It completes normally but ends with an error in the log file. I have been semi-successful deleting the records returned from this query that are older than trunc(sysdate) but not always. Does
anybody know why it isn't purging the old data and completes in an error?