Re: Disable Rollback

From: Ed prochak <ed.prochak_at_magicinterface.com>
Date: 22 Dec 2003 09:32:27 -0800
Message-ID: <4b5394b2.0312220932.6441b787_at_posting.google.com>


tkumar_at_ipolicynet.com (Tuhin Kumar) wrote in message news:<e4ad76f5.0312220302.589fdd83_at_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 Received on Mon Dec 22 2003 - 18:32:27 CET

Original text of this message