Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Myths

Re: Oracle Myths

From: Pascal Byrne <p_byrne76_at_hotmail.com>
Date: 17 May 2002 03:23:23 -0700
Message-ID: <c1d21c59.0205170223.3a361816@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 Received on Fri May 17 2002 - 05:23:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US