Rollback segments again
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Rollback segments again

  1. #1
    Join Date
    Mar 2001
    Posts
    52
    Hi,
    I have read about rollback storage parameters in all kind of documentation
    And I am not sure if MINEXTENTS should be 10,8,20 or x.
    Could somebody explain why should be 10 or 20 and what is the impact if MINEXTENTS =2.

    And if I don't ask to much
    Is there a documentation that explain in depth how to interpret for example V$ROLLSTAT

    Thank you!

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    It depends on your application. How big do your RBS need to be? What is your INITIAL and NEXT extent settings in the RBS tablespace? What is the relationship of your OPTIMAL RBS settings and your MINEXTENTS?

    Personally, I like to have my minextents = the number of extents that will comprise my RBS when they are at their OPTIMAL size.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Mar 2001
    Posts
    52
    1.Big and small
    2. INITIAL=NEXT for RBS tbs
    3.OPTIMAL= INITIAL_EXTENT * INITIAL_EXTENT

  4. #4
    Join Date
    Mar 2001
    Posts
    52
    Sorry!
    I mean

    1.Big and small
    2. INITIAL=NEXT for RBS tbs
    3.OPTIMAL= INITIAL_EXTENT * MIN_EXTENTS

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    If you already know what your OPTIMAL setting will be, just figure out the number of extents it will take.

    PS. IMHO, there should be no such thing as "big" rbs and "small" rbs. All your RBS should be sized properly as to avoid ORA-1555 error messages.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Mar 2001
    Posts
    52
    1.Big and small transactions

    Thank you

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    a large minextents is to avoid dynamic extensions and blocking sessions

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