Re: Reducing rollback segment tablespace sizes

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 to reduce the chance of a 1555.

Daniel Fink

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 . . . RESIZE . . . it won't let
> me resize it at all (it has extents scattered throughout). Anyone know how I
> go about shrinking it? Do I have to create a new tablespace/datafile, then
> drop the old one?
>
> TIA,
>
> Michael Milligan
> Oracle DBA
> Ingenix, Inc.
> 2525 Lake Park Blvd.
> Salt Lake City, Utah 84120
> wrk 801-982-3081
> mbl 801-628-6058
> michael.milligan_at_ingenix.com
>
> This e-mail, including attachments, may include confidential and/or
> proprietary information, and may be used only by the person or entity to
> which it is addressed. If the reader of this e-mail is not the intended
> recipient or his or her authorized agent, the reader is hereby notified that
> any dissemination, distribution or copying of this e-mail is prohibited. If
> you have received this e-mail in error, please notify the sender by replying
> to this message and delete this e-mail immediately.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Michael Milligan
> INET: Michael.Milligan_at_ingenix.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Fink
  INET: Daniel.Fink_at_Sun.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).