-
Hi,
I have created partitions, re created the indexes, am using a large rollback segment, have set the table for nologging
and also commiting every thousand records.....
All these I am doing to delete around 2lakh records from a table.
What other parameters should I check to make the deletions faster, Now the deletions are taking a very long time and testing our patience.
Badrianth
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
|