Re: Disable Rollback

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 26 Dec 2003 09:18:20 -0800
Message-ID: <1efdad5b.0312260918.5d9aeb9_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

#1. no you cant turn off rollback
#2. your problem is that you are running your delete in a loop. just use sql. when you put sql inside of loops it is VERY slow #3. disable all indexes, will speed it up.

Easiest method is a 'create table as' nologging and copy the records you need. Drop the old table. Rename new table to old table. create indexes with dbms_job so they all go at once. Received on Fri Dec 26 2003 - 18:18:20 CET

Original text of this message