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

Thread: coalesce RBS?

  1. #1
    Join Date
    Jan 2001
    Can you coalesce the RBS tablespace and it will have the same significant effect just like other tablespaces?

    my bear

  2. #2
    Join Date
    Oct 2000
    Saskatoon, SK, Canada
    I doubt that you could coalesce the RBS, but even if you could they are ment to act like a rubber band where they can expand for their wish and shrink to the optimal point.

    Interesting question, interested to see what others has to say on this regard.


    Life is a journey, not a destination!

  3. #3
    Join Date
    Dec 2000
    Ljubljana, Slovenia
    Sure you can coalesce the RBS tablespace, it is just the same as any other tablespace. The database sistem could not have any idea that a particular tablespace is ment only for rollbacks (as opposed to TEMP tablespace, if you create it as "TEMPORARY"). You also can't stop users to create tables or indexes in RBS tablespace, unles you revoke them quota on that tablespace!

    So as far as Oracle is concerned, RBS is just the same as any other tablespace. The only tablespace that is special is temporary tablespace if it was created as TEMPORARY. So there is nothing to stop you from coalescing RBS tablespace.

    But I would not recomend you to do so, unless you have rolback segments of different extent sizes (which you shouldn't have in the first place). If all rollback's extents are equaly sized, the more the tablespace is "fragmented", the less work the system have to do when it have to extend a rollback segment. If you coalesce the RBS tablespace, the performance won't improve, it will degrade. Although this degradation in performance will be so minimal that noone will ever notice....

    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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