469,898 Members | 1,550 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Rollback problem

Hi all,

I have a problem with rollback segment. I am a beginner and do not have
much knowledge of DBA.

Anyways, the problem is there is a transaction of around 105 MB. This would
not fit into the normal rollbacks created and gave an error of "maxextents
for rollback reached", so our DBA created a rollback of 500 MB and I used
this rollback for the transaction by using the "set transaction" command.
But even then the error continued. So I split the transaction by giving
"commits" (and then set transaction again) in the transaction. But the
error continued. The DBA then gave next extent of 50 MB and maxextents 80.
But, yes, the error continued. Now I have given a commit after *every*
insert and update and each transaction is less the 5 K, but the error still
continues.

I don't know what else I can do and the DBA is asking me to split the
transaction further. This I cannot do unless I give an insert, for say 10
columns, commit it and then update the same record for balance 10 columns. I
am at a total loss. I don't think I need to split the transaction further
as it is less than 5 K. Can someone please suggest what could be the
problem?

Thanks and regards,
Alice
Jul 19 '05 #1
2 2569
Please post the error message and Oracle version, and then we might be able to help.

Daniel
Jul 19 '05 #2
"Alice" <al***@reply-to-group.com> wrote in message news:<40********@news.tm.net.my>...
Hi all,

I have a problem with rollback segment. I am a beginner and do not have
much knowledge of DBA.

Anyways, the problem is there is a transaction of around 105 MB. This would
not fit into the normal rollbacks created and gave an error of "maxextents
for rollback reached", so our DBA created a rollback of 500 MB and I used
this rollback for the transaction by using the "set transaction" command.
But even then the error continued. So I split the transaction by giving
"commits" (and then set transaction again) in the transaction. But the
error continued. The DBA then gave next extent of 50 MB and maxextents 80.
But, yes, the error continued. Now I have given a commit after *every*
insert and update and each transaction is less the 5 K, but the error still
continues.

I don't know what else I can do and the DBA is asking me to split the
transaction further. This I cannot do unless I give an insert, for say 10
columns, commit it and then update the same record for balance 10 columns. I
am at a total loss. I don't think I need to split the transaction further
as it is less than 5 K. Can someone please suggest what could be the
problem?

Thanks and regards,
Alice


dear Alice,
with my little experience I have few suggetions.
1.try it with new installation of Oracle with minimal data and keeping
all the settings to default as possible.If it works,you get a clue.
2.You can always manualy rollback the transaction if you can handle
all the
side effects properly.e.g. delete for insert and update for update
with values maintained in temp table(you need pl-sql).It is bad
way,but something is better
than nothing
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Tuhin Kumar | last post: by
reply views Thread by Brent Mondoux | last post: by
3 posts views Thread by level8 | last post: by
2 posts views Thread by mahajan.sanjeev | last post: by
2 posts views Thread by mahajan.sanjeev | last post: by
1 post views Thread by Joăo Santa Bárbara | last post: by
2 posts views Thread by Ian Boyd | last post: by
2 posts views Thread by Alice | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.