Just a note on the topic of PCTINCREASE.
According to the book "Advanced Oracle Tuning and Administration", you
should set PCTINCREASE at the tablespace level to a non-zero value for all
tablespaces except SYSTEM, temporary, and rollback. You should then specify
a PCTINCREASE of zero for the tables as they are created. The non-zero
PCTINCREASE at the tablespace level allows the SMON process to coalesce
free exents automatically. In 7.3 you can also do this via ALTER
TABLESPACE tspace-name COALESCE;
--
Thomas W. Vanya
Oracle and OracleRdb Database Administrator
Eastman Chemical Company
Received on Tue Aug 05 1997 - 00:00:00 CDT
