Setting pctincrease 0 at the tablespace level

From: Dino Hsu <dino1_at_ms1.hinet.net>
Date: Sun, 27 May 2001 21:38:29 +0800
Message-ID: <ia02ht0iku7utfb2t6fkocr0geecrjkkig@4ax.com>

Dear all,

In a book, it says:
"Note: Setting pctincrease to 0 at the tablespace level affects ORACLE's ability to automatically coalesce free space in the tablespace. Set the default pctincrease for the tablespace to a very low value, such as 1."

My questions:

1.Why the free-space-coalescing problem?
2.Do you think pctincrease=1 is good?
3.Do you think fixed extent size stand well most of the time?

Thanks, Dino

Source:
p.129, Kevin Loney, Oracle 8i DBA Handbook, Ch4. Physical Database Layout->
Database Space Usage Overview->
Implications of the storage Clause Received on Sun May 27 2001 - 08:38:29 CDT