tk****@ipolicynet.com (Tuhin Kumar) wrote in message news:<e4**************************@posting.google. com>...
Hi,
Is It possible to disable rollback in Oracle 9i. I am running it
in a loop deleting 2000 records at a time. The maximum performance I
am able to get is 3 lakhs records in 20 minutes. I am looking forward
to 1 million in 10 minutes, but it seem because of rollback been
enabled I am unable to do so. Is there any other
way also to improve the deletion rate.
Thanks,
Tuhin
DO you even understand what rollback is?
You are seeking the wrong solution to your problem. You need to look
at your process. Are the rows you delete primary records, and there
are cascading deletes in one or more child (foreign key) records? How
are you selecting the rows t be deleted? There are just so many things
wrong with your question, that I don't know where to begin to answer
you.
and BTW, what is a "lakhs" ???
Ed