Re: Oracle Myths

From: Eric <eric_at_deptj.eu>
Date: Mon, 9 Feb 2015 18:19:22 +0000
Message-ID: <slrnmdhuha.olv.eric_at_bruno.deptj.eu>


On 2015-02-09, arerix_at_gmail.com <arerix_at_gmail.com> 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?

Eric

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

Original text of this message