RE: Reducing rollback segment tablespace sizes

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 throughout the tablespace, preventing me from resizing the datafile.

Thanks,

Mike

-----Original Message-----
Sent: Monday, November 17, 2003 2:44 PM
To: Multiple recipients of list ORACLE-L

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
>

Waow !!! A true, live Oracle 6 database ?

AFAIK, PCTINCREASE has been hard-coded to 0 for rollback segments since the beginnings of Oracle 7.

Concerning your question, it all depends on where your existing rollback segments are located in the datafile (look at dba_extents). All you have to do is drop and recreate each roolback segment in tirn.

Now, if this really is an Oracle6 database, RESIZE doesn't work ...

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.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).


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).