| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Error I'm getting: ORA-01599, trying to put many rollback segments online
A copy of this was sent to "Brendan Newman" <brnewma_at_ibm.net>
(if that email address didn't require changing)
On Thu, 22 Oct 1998 14:19:00 -0400, you wrote:
>Hi there,
>
> I'm trying to put about 400 rollback segments online (50K each). I
>currently allocated 1 Gig to my rollback space. Each time I run a script
>that goes sequentially through the offline segments, it crashes in the
>middle with an oracle error:
>
>ORA-01599 failed to acquire rollback segment "name", cache space is full
>(currently has 29 entries)
>
> Oracle on-line documentation says "the amount of allocated space is not
>enough". How do I increase "allocated" space? Is there a variable in the
>InitSID.ORA file that I need to set?
>
>Any help would be much appreciated.
>
>Thanks,
>
>Brendan
>
>
Well, in answer to your question:
$ oerr ora 1599
01599, 00000, "failed to acquire rollback segment (%s), cache space is full
(currently has (%s) entries)"
// *Cause: the amount statically allocated is not enough based on // max_rollback_segments parameter. // *Action: For now take another rollback segment offline or increase the // parameter max_rollback_segments
But now a question for you -- 400 rollback segments of 50k each? Why? It'll take us longer to find a rollback segment for you with that many small ones. Why not fewer rbs's with more space (and more extents in each one)....
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Thu Oct 22 1998 - 14:14:08 CDT
 |
 |