SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Commit after delete

FilipFryMay 7 2010 — edited May 10 2010

I have a job that process data for last 7 days. Most of data(90%) is processed in first iteration(first day) after what i delete processed data and do a commit. What is strange is that job continues to work slow as if there is same amount of data like there was before deleting. How to improve performances?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 7 2010

Added on May 7 2010

#delete

6 comments

1,370 views