uRGENT-dELETE LARGE NUMBER OF ROWS

[urchin556]

I need to write a procedure which will purge a table having more than 8 crores records based on the parameter passed by the user.We have open a cursor and in loop we are deleting one by one and when the count reaches 50,000 we issue commit so the rollback segment problem can be avoided.But this is taking plenty of time...very very slow.Is there any other way through which we can improve the perfomance.Instead of deleting one by one is it possible to delete 20000 rows in a fetch.
Please suggest

 

[SantaMufasa]

Urchin,

To advise you on options, please advise the following:

Number of total rows in the table prior to delete.
Number of total rows in the table following delete.

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.