Re: RBS Tablespace is growing, Help!

Read up on the use of the OPTIMAL setting for your rollback segments (ALTER ROLLBACK SEGMENT). If you do not specify an OPTIMAL setting, your RBS's will always remain at the high water mark. By specifying an optimal to something much smaller, your individual rollback segments will periodically shrink back to the optimal setting. There is obviously a trade off in performance when the RBS have to extend, but it can help you keep your RBS under control.

Also, if you have a well defined set of transactions that are the cause of your RBS extending to large proportions, you may want to look into forcing these transaction to use a separate rollback segment in a different tablespace (i.e. RBS_LARGE) that is setup specifically for large transactions. To do this, you would need to utilize the USE ROLLBACK SEGMENT option to the SET TRANSACTION statement within your transaction code.

See the Server SQL Reference manual.

In article <313444A9.41C67EA6_at_norman.informatik.uni-bremen.de>, oracle_at_norman.informatik.uni-bremen.de says...
>
>The contents of my Tablespace RBS is growing day by day (now it's up to
>36 MB), Why?
>How do i get him smaller?
>
>Thanks for any ideas!
>
>O. Bergst
>
>oracle_at_norman.informatik.uni-bremen.de
Received on Sun Mar 03 1996 - 00:00:00 CET