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