Re: undo header congestion? (8.0.5)

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Tue, 20 Jan 2004 18:28:23 +0100
Message-ID: <k5pq0090ic8ugga0na3bjprcih902r44fs@4ax.com>

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.

--
Sybrand Bakker, Senior Oracle DBA

Received on Tue Jan 20 2004 - 11:28:23 CST