Disable Rollback
From: Tuhin Kumar <tkumar_at_ipolicynet.com>
Date: 22 Dec 2003 03:02:33 -0800
Message-ID: <e4ad76f5.0312220302.589fdd83_at_posting.google.com>
Date: 22 Dec 2003 03:02:33 -0800
Message-ID: <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
Received on Mon Dec 22 2003 - 12:02:33 CET