I have a client where rollback segments were set up RBS01-RBS05, all in a
tablespace called RBS. The person who set it up set %INCREASE at 50%. Well,
I shrank the segments to themselves down to less than 500MB total from
4.6GB! But in using ALTER DATABASE DATAFILE . . . RESIZE . . . it won't let
Michael Milligan wrote:
I have a client where rollback segments were set up RBS01-RBS05, all in a
tablespace called RBS. The person who set it up set %INCREASE at 50%. Well,
I shrank the segments to themselves down to less than 500MB total from
4.6GB! But in using ALTER DATABASE DATAFILE . .
Micheal,
Could you shrink the rbs even smaller? This should work if the first two
extents of each rbs are in the 'first' blocks of the datafile. If not, the best
solution is to create new smaller ones as you drop the others and then resize.
Regardless of the solution, do this during a slow time
.
HTH
Jared
Michael Milligan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/17/2003 01:29 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Reducing rollback segment tablespace sizes
I have a client where
Thanks for the info.
It's 8.1.7.4, and it's not hard-coded. I changed it from 50% to 0%, but the
damage had been done. Maybe you're just nostalgiac for the good old days of
v6!
I did set an optimal, and used shrink. That worked fine to shrink the
segments, but they are still scattered
Daniel,
Thank you very much. I'll do what you suggested, on both counts. I'll try
shrinking them more first, then create new ones if needed.
Thanks again,
Mike
-Original Message-
Sent: Monday, November 17, 2003 2:49 PM
To: Multiple recipients of list ORACLE-L
Micheal,
Could you