Re: Can not place rollback segment online

Thanks for all those replied.

have a nice day!

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, February 03, 2003 9:33 PM

> Shuan - If you go to
> http://www.google.com/search?hl=en
> <http://www.google.com/search?hl=en&ie=ISO-8859-1&q=max_rollback_segments>
> &ie=ISO-8859-1&q=max_rollback_segments
> you can find a lot of information on this parameter. Oracle needs to
> allocate a finite amount of memory to manage rollback segments, so there
> must be a upper boundary somewhere. Unfortunately, you've hit it and must
> bounce your instance to change it. Just think of it as your lucky day. ;-)
>
>
>
> Dennis Williams
> DBA, 40%OCP
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> Sent: Monday, February 03, 2003 6:49 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Dear all DBAs,
>
>
> i'm using Oracle 8.0.5 on Linux 6.4 kernel 2.2.14.
> when i try to place the rollback segment online,
> it show error as below:
>
> SQL> ALTER ROLLBACK SEGMENT "RB28" ONLINE;
> ALTER ROLLBACK SEGMENT "RB28" ONLINE
> *
> ERROR at line 1:
> ORA-01599: failed to acquire rollback segment (28), cache space is full
> (currently has (29) entries)
>
> If use oerr ora 1599, then
> the solution it showed is to "take another rollback segment offline or
> increase the
> parameter max_rollback_segments"
>
> so that means the current rollback segment number is exceeded the
> max_rollback_segment?
> where's this max_rollback_segment?
>
> Thanks in advance.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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: =?big5?B?c2h1YW4udGF5XChQQ0m+R7hSs9RcKQ==?=
  INET: shuan.tay_at_pci.co.id

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