Re: Oracle Myths

From: Mike Ault <mikerault_at_earthlink.net>
Date: 22 May 2002 11:54:45 -0700
Message-ID: <37fab3ab.0205221054.4bb033b7@posting.google.com>

p_byrne76_at_hotmail.com (Pascal Byrne) wrote in message news:<c1d21c59.0205170223.3a361816_at_posting.google.com>...
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3ce21b71$0$8510$ed9e5944_at_reading.news.pipex.net>...
> > PCTIncrease should be as small as possible but non-zero to minimize
> > tablespace fragmentation.1% is a good value (from my OCP course notes though
> > not necessarily given by the tutor!)
>
> I've seen this quoted in a recent paper by Michael R. Ault (author of
> "Oracle8i Administration and Management"). The reason given was that
> SMON will not coalesce free space if PCTINCREASE is zero. Is this
> definitly a myth?
>
> -Pascal

I haven't posted that in a recent paper...what do you consider recent? It is however true. But I agree, if you are using proper management then it is not required. As to the 1%, I believe it was an arbitrary number incase someone didn't specify storage at the table or index level to prevent outrageous growth. As long as proper storage is included with create commands it really doesn't matter. Of course if people would always specify proer storage then this discussion wouldn't be here would it!

Mike Received on Wed May 22 2002 - 13:54:45 CDT