Re: Oracle Myths
From: <arerix_at_gmail.com>
Date: Mon, 9 Feb 2015 04:59:11 -0800 (PST)
Message-ID: <e5663642-10bf-4ad7-ab1d-65d878bcd333_at_googlegroups.com>
Date: Mon, 9 Feb 2015 04:59:11 -0800 (PST)
Message-ID: <e5663642-10bf-4ad7-ab1d-65d878bcd333_at_googlegroups.com>
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