| rollback segment too small ora-01555 [message #539965] |
Thu, 19 January 2012 10:07  |
Andrey_R
Messages: 441
Registered: January 2012
Location: Israel
|
Senior Member |
|
|
Hi All,
One of the users received the error
ora-01555: rollback segment too small
I have read about the error and saw that it is caused by transactions made upon same data, filling to maximum one of the UNDOTBS rollback segments.
It happens only once in a while, each time on a different Rollback Segment.
I've read that i should do a few things to enlarge those segments, such as bring a 1. segment offline, 2. drop it and then 3. create it with a bigger size & possibly a bigger extent setting
However,
i've also read that those actions aren't relevant if you have the parameter UNDO_MANAGEMENT set on AUTO, which is actually the case.
is that why when i execute
ALTER ROLLBACK SEGMENT RB_SEG_NAME_11$ OFFLINE;
and then
1. How do i solve my issue with the
the Rollback segment being too small to contain the snapshot with the requested SCN?
2. what does the parameter UNDO_MANAGEMENT mean?
should i change it, in order to adjust my Rollback Segments attributes, to prevent my error of re-occurring?
Sorry for the silly questions,
Great Thanks to those trying to help,
Andrey
|
|
|
|
|
|
|
|
| Re: rollback segment too small ora-01555 [message #539987 is a reply to message #539974] |
Thu, 19 January 2012 10:34  |
Andrey_R
Messages: 441
Registered: January 2012
Location: Israel
|
Senior Member |
|
|
Hi Michael,
as i said, i have an Oracle version of 11g.
you have posted link to documentation of 10g.
Other then that, there was so much information there, you could'ave sent me straight to the bible, and look for the answer there.
What i asked was specifically about the issue of rollback segments in 11G, and if you are unable to help - please don't try to insult with these kind of replies.
I know i ask silly questions, since i am a beginner,
but it doesn't mean you have to post silly answers.
can anyone please assist regarding the specified issue?
Regards,
Andrey
|
|
|
|
|
|
|
|
| Re: rollback segment too small ora-01555 [message #539993 is a reply to message #539990] |
Thu, 19 January 2012 10:49 |
Andrey_R
Messages: 441
Registered: January 2012
Location: Israel
|
Senior Member |
|
|
Hi Michel Cadot,
First of all, i want to apologize if i went too far with my reply.
Secondly, I have read SOME Oracle Documentation and didn't find an answer there(or understand it),
sending me to it seems to be just avoiding the question asked.
Still, sorry and thanks for your reply.
BlackSwan,
Thank you for your kind reply.
I understand that reducing the number of COMMIT actions will solve my problem,
however, it does not happen over customer sites, only our local environment.
If we change the code here, we have to change it everywhere, meaning, in places where it WORKS,
so it's a problem, in addition to the fact that it occurs only on our local environment.
What method do you suggest to check amount of commits per some time on an environment\schema?
i do not have the Statistics & Diagnostic pack license for running an AWR report.
Thanks again,
Andrey
|
|
|
|
|
|
|
|
|
|
| Re: rollback segment too small ora-01555 [message #540391 is a reply to message #540390] |
Mon, 23 January 2012 04:40 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
It may or may not be useful depending on the origin of the error.
This origin must be determined FIRST in order to "prevent my error of re-occurring" (OP¨request).
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
