-
Deleting records takes long time and unltimately servers hang
We have a simple query to delete huge records (Keeping only records from last two days) from database and it runs during night time. But it takes around 45 mins and by that time transactions just wait for data and servers utilization go high.
delete from table where date < sysdate-2;
Any suggestions or ulternatives how we can improve the time of this job?
Your help will be greatly appreciated!
Thanks in advance!!!
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|