By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,502 Members | 1,878 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,502 IT Pros & Developers. It's quick & easy.

Disable Rollback

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
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
Jul 19 '05 #2

P: n/a
al0
> 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.


As it was noticed by one of the respondents your are searching for a
wrong answer, probably the best thing that you can do, go to the
asktom.oracle.com
web site and perform search (e.g. for "snapshot too old" message). You
will find the perfect explanation of your troubles.
Regards,

Oleksandr Alesinskyy
Jul 19 '05 #3

P: n/a
1 lakh is 100,000 if I remember my Indian terminology correctly

but the wider question is should companies be hiring staff who ask
these kind of Oracle questions or perform these kinds of operations
Jul 19 '05 #4

P: n/a

"michael newport" <mi************@yahoo.com> wrote in message
news:63*************************@posting.google.co m...
1 lakh is 100,000 if I remember my Indian terminology correctly

but the wider question is should companies be hiring staff who ask
these kind of Oracle questions or perform these kinds of operations


Because they think they are saving money.
Jim
Jul 19 '05 #5

P: n/a
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


#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.
Jul 19 '05 #6

P: n/a
mi************@yahoo.com (michael newport) wrote in message news:<63*************************@posting.google.c om>...
1 lakh is 100,000 if I remember my Indian terminology correctly

but the wider question is should companies be hiring staff who ask
these kind of Oracle questions or perform these kinds of operations


Thanks, Mike.

And I wonder when we ask for further info and they do not followup,
what is going on? Did they find an answer somewhere else? Do they
not even read our comments? Are they still looking for an answer? Who
knows?

have a happy New Year!
Ed
Jul 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.