Re: ORA 1562 Rollback segment problem
Date: 1995/05/02
Message-ID: <3o64q1$khc_at_pandora.sdsu.edu>#1/1
If you are running oracle 7 you can specify a min size, and max size and a optimal size. We have a 100m tablespace divoted to rollback, and three rollback segments with optimal size of 20M. This allows any one of them to grow to 60M before giving us the "unable to allocate rollback" message. At times we still get the message. For those jobs I have one other tablespace with a single rollback segment. I bring the rollback segment on line an assign the large transaction to the segment.
Take a look in the DBA guide under rollback segments. The command to assign a transaction to a rollback segment is something like: set transaction use rollback segment BIG_ROLLBACK;
Greg Tupper
SAIC Comsystems
gtupper_at_nosc.mil
Received on Tue May 02 1995 - 00:00:00 CEST