Re: odd number of rollback segments

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Thu, 31 Aug 2006 20:55:01 GMT
Message-ID: <J4vrFu.2zB@igsrsparc2.er.usgs.gov>

joel garry wrote:
> 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#
>

I was just explaining *why* one of the rollback segments may have been larger than the other. I should have provided your caveat the OPTIMAL should not be used. But then...use Automated Undo and start living!!!

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Thu Aug 31 2006 - 15:55:01 CDT