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

From: Ivan Bajon <iba_at_no_spam@post1.tele.dk>
Date: Tue, 19 Oct 1999 12:32:39 +0200
Message-ID: <7uhhcb$6tt$1@news.inet.tele.dk>

Actually you should have a minimum of 20 extents in each rollback segment. That's minextents=20. This is to avoid dynamic allocation/deallocation of extents during everyday use. Now using the other storage parameters (maxextents etc.) you can control the size and number of extents, what the optimal size should be etc.

Regards,
Ivan Bajon, OCP

ragu sekar <raguc_at_yahoo.com> wrote in message news: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 Tue Oct 19 1999 - 05:32:39 CDT