470,596 Members | 1,331 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,596 developers. It's quick & easy.

Disable Rollback

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
6 11326
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
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
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

"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
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
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.

Similar topics

5 posts views Thread by tkestell | last post: by
2 posts views Thread by Alice | last post: by
1 post views Thread by anders_tung | last post: by
3 posts views Thread by level8 | last post: by
16 posts views Thread by Barry Gilmore | last post: by
1 post views Thread by cheesey_toastie | last post: by
2 posts views Thread by Ian Boyd | last post: by
6 posts views Thread by Tuhin Kumar | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.