Re: Oracle Myths

From: <>
Date: Mon, 9 Feb 2015 04:59:11 -0800 (PST)
Message-ID: <>

onsdag 15. mai 2002 10.25.36 UTC+2 skrev Niall Litchfield følgende:
> 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!)

When I was DBA on Oracle 7.3.4 I always set pctincrease on tables (not tablespaces) to 1% to trigger autocoalesce on extents. Perhaps this was a myth too? I can't check anymore, our 7.3.4 database was shut down late 2011. Received on Mon Feb 09 2015 - 13:59:11 CET

Original text of this message