473,322 Members | 1,493 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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 11655
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: tkestell | last post by:
Is their anyway to perform mass deletes (several million records) without "maxing out" rollback segments? I'm working on archiving data from an Oracle 8.1.7 database The system is about 4 years...
2
by: Alice | last post by:
Hi all, Given a rollback segment with storage as follows : Initial Extent 5 MB Next Extent 5 MB Min Extents 20 Does this mean that every time a transaction uses this rollback segment it...
1
by: anders_tung | last post by:
Hi, I have a procedure which will call 3 functions. First function will update a record. Second function will delete a record. Third function will insert a record. Each function will return...
3
by: level8 | last post by:
Hi, Everybody, I'm a Hungarian SQL user and I need a little help for SQL Server 7 ! I protect my table against bad data with a trigger. I use ROLLBACK and RAISERROR statement in this trigger....
5
by: byte.this | last post by:
I have the Service Pack installed, but this program is just plain buggy. I don't even WANT it, but I couldn't get my ATI drivers to install unless I had it on the system. I don't mind if the...
16
by: Barry Gilmore | last post by:
Is there a way to disable a button after it is clicked? I am trying to avoid having someone click on it twice while they wait for it to process. Thank you!
1
by: cheesey_toastie | last post by:
I have a long query which I have set off and would like to stop, and rename one of the tables used. My query is due to my lack of understanding of the underlying structure of MSSQL-Server... ...
2
by: Ian Boyd | last post by:
We're encountering a situation where we're encountering a deadlock, and someone's been made the deadlock victim. But after that, DB2 refuses to run any SQL, and instead we get the error message: ...
6
by: Tuhin Kumar | last post by:
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...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.