Re: Oracle Myths

From: Eric <>
Date: Mon, 9 Feb 2015 18:19:22 +0000
Message-ID: <>

On 2015-02-09, <> wrote:
> 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.

I have a vague memory of this but I'm not sure of the facts. But you do realise that you are replying to a 13-year old post?


ms fnd in a lbry
Received on Mon Feb 09 2015 - 19:19:22 CET

Original text of this message