-
Hi Friends,
Some days I get the following errors in my alert log:
FULL status of rollback segment 20 set.
failure to extend rollback segment 20 because of 1237 condition.
failure to extend rollback segment 20 because of 1562 condition.
After about 2 hours, I get the message saying that FULL status of rollback segment 20 is cleared and from then on there are no more messages .
My database is having two instances(OPS) and I have 6 rbs for each instance.Their sizing details are:
INITIAL 80M NEXT 80M MINEXTENTS 2 OPTIMAL 160M
How can I avoid the 1562/1237 errors? And how can I clear the FULL status myself instead of letting Oracle do in its own time?
All help is appreciated.
Thanks
manjunath
-
Looks like that you are ending up in an open transaction, where the user is not doing the commit. Take a look into this metalink note on how to fix this problem
http://metalink.oracle.com/metalink/...1&p_showHelp=1
Sam
Thanx
Sam
Life is a journey, not a destination!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|