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

Thread: RBS Question

  1. #1
    Join Date
    Oct 2000

    RBS Question


    Every week when we run batch jobs, and a rbs is used and after data is committed, it still takes certain time to shrink.. Meanwhile if any other transaction is growing it does not have enough extents and fails due to that? I have already increased RBS tablespace to about 5GB and cannot increase more and more..

    What is the best way to deal with this situation. I don't know how it will react if I shrink it manually. Are there any parameters to deal with this?

    Thanks, ST2000

  2. #2
    Join Date
    Dec 2002
    Set optimal size for rollback segments
    alter ROLLBACK SEGMENT rb_large storage (optimal 50m);

    I think that even some rollback segments are bigger(after commit), the space is still reuseable (not 100% sure).

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