Re: Optimal size for rollback segments

From: Lawrence <lsimela_at_mahalini.prestel.co.uk>
Date: Mon, 2 Nov 1998 02:40:54 -0000
Message-ID: <71la0s$lr2$1@phys-ma.sol.co.uk>

Now, my understanding is that rollback segments are always used in a round robin fashion irrespective of whether you have OPTIMAL set or not. OPTIMAL is used to ensure that the rollback segments do not extend to such a large size that we have too many old transactions.. It forces the segments to shrink themselves to the OPTIMAL size.. otherwise all the tablespace would be used by possibly one large transaction

Lawrence

Serge Montet wrote in message <71a4je$16o_at_work.wanadoo.com>...
>Hello
>
>I am not very clever, that's why I cannot understand the advantage to
>specify OPTIMAL size for rollback segment.
>Indeed, if we don't specify this storage clause, the rollback segment uses
a
>sort of 'round bind' algorithm. So what's the difference ?!
>
>Thanks...
>
>
>
>
Received on Sun Nov 01 1998 - 20:40:54 CST