Re: understanding RBS - Guidelines

On Wed, 30 Apr 1997 11:00:24 +0200, Geert De Paep <gdp_at_cimad.be> wrote:
>* Set MINEXTENTS and OPTIMAL so that you have 10 extents per RBS.
>* select wraps from v$rollstat; should not increase too often,
> otherwise take bigger extents.

Hi Geert,

Most other recommendations I have seen suggest 20 to 30 extents per RBS. Your recommendations imply that there is a cost to wraps that ought to be minimised, or perhaps a risk that ought to be reduced. If so, can you please describe that cost/risk, or comment on why you do not recommend a larger number of extents to maximise the potential space usage of active extents.

Steve Adams Received on Sat May 03 1997 - 00:00:00 CDT