Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can not place rollback segment online
Thanks for all those replied.
have a nice day!
> 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).Received on Mon Feb 03 2003 - 19:28:57 CST
![]() |
![]() |