Re: logical storage philosophy?

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 14 May 2001 22:07:57 -0700
Message-ID: <3B00B9AD.B467F18E@exesolutions.com>

Bruno Jargot wrote:

> On Sun, 13 May 2001 23:29:44 -0700, Daniel A. Morgan wrote:
>
> >Sybrand Bakker wrote:

> >> Use equally sized extents and pct_increase 0, and maxextents unlimited in
> >> Oracle 7.3 and 8.0
> >
> >A bit of extension if I might.
> >
> >If you are building tablespaces in 7.3 or 8.0 make the pct_increase on the
> >tablespaces 1%. But be absolutely sure that you specify pct_increase of 0% in
> >every single table and index create statement as Sybrand suggests. The first
> >parameter will make sure that SMON coalesces freespace. The second will make
> >sure that you don't fragment the tablespace. Under no conditions build a table
> >or index without specifying a storage clause.
>
> If all extents are equally sized, there will not be fragmentation of
> the tablespace and the coalescing of free space is totally useless.

You are, of course, assuming that they will all be of the same size which is highly unlikely in the real world except in 8i with locally managed tablespaces.

Otherwise I agree with you.

Daniel A. Morgan Received on Tue May 15 2001 - 00:07:57 CDT