Unable to Extend Rollback Segment - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Unable to Extend Rollback Segment

  1. #11
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    I dont understand your question, are you asking how to size or you mean why you hit the error....?

  2. #12
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Now I know why I hit the error... Thanks for the help.

    The question was about basics in sizing Rollback segments and things to keep in mind.
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  3. #13
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Sizing RBS is an iterative process.

    Query from v$rollstat when the db has high volume of transactions.
    The aveactive column value will be the starting size (for initial and next) for the RBS.

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