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
The high water mark for the rollback segments is preventing you from shrinking the files.
Use alter rollback segment SEGMENT_NAME storage ( optimal OPTIMAL_SIZE)
to set an optimal size for the segment, then use 'alter rollback segment SEGMENT_NAME shrink'
to shrink the rollback.
You may want
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