DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: failure to extend rollback segment 20 because of 1562 condition

  1. #1
    Join Date
    Oct 2000
    Posts
    211
    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

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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
  •  


Click Here to Expand Forum to Full Width