Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: odd number of rollback segments
Brian Peasland wrote:
> Because someone created the rollback segments different. Either that, or
> they have allocated additional extents with no OPTIMAL setting causing
> the rollback segment to shrink back to 2M.
>
Hoping there is a typo there.
In general, don't use OPTIMAL, it causes ORA-1555 by shrinking rollbacks at inopportune times. Make all the rollbacks nice and big, big enough for all normal processing, and the same size (except perhaps if you have some known batch processing that makes unusually large transactions, in which case you need to control the assignment manually anyways).
jg
-- @home.com is bogus. The $36000 bathtub: http://www.annsacks.com/onlinecatalog/program.jsp?cat=272204&coll=304904&prg=320404#Received on Thu Aug 31 2006 - 15:35:16 CDT
![]() |
![]() |