Re: Rollback segments - Is it better to have 2 or 10 extents

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 21 Oct 1999 00:09:13 +0100
Message-ID: <940462102.22718.2.nnrp-10.9e984b29@news.demon.co.uk>

The reason why 2 extents is bad is that a transaction that starts in one extent and crosses into the second extent makes the entire rollback segment unavailable for any other transaction to start. (True up to 7.3, but I haven't checked it for 8.0, 8.1).

10 is better because this denial of access still leaves 8 extents for other transactions to start in. --

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

ragu sekar wrote in message <380b465e_at_www2.iaol.com>...
>
>Hi
>
>I read somewhere that it is better to have 10 extents for a rollback
segment than just 2 extents? Pl comnfirm or contrast this/ Thanks
>
>ragu
Received on Wed Oct 20 1999 - 18:09:13 CDT