Re: undo header congestion? (8.0.5)

From: Bjørn Augestad <boa_at_metasystems.no.spam.to.me>
Date: Tue, 20 Jan 2004 19:33:18 GMT
Message-ID: <2ofPb.30977$BD3.6794887@juliett.dax.net>

Sybrand Bakker wrote:

> On Tue, 20 Jan 2004 15:47:40 +0100, Bjorn Augestad
> <Bjorn.Augestad_at_bokklubbene.no> wrote:
>
>

>>Some additional info: instance 1 has two rollback segments, and instance 
>>2 has just one (+ system).

>
>
>
> The number of rollback segments should be set according to the rule of
> four: per 4 users 1 rollback segments, with a minimum of 4 rollback
> segments, and rounded up.
> Consequently both instances have too few rollback segments, which is
> confirmed by the number of waits on the undo header block.
>

Thank you for answering. :-)

Would you(or anyone else) consider it a serious case of misconfiguration to set up an instance with just one/two rollback segments, assuming 25-50 users?

Regards,
Bjørn Received on Tue Jan 20 2004 - 13:33:18 CST