
406 14.2 Tuning Hardware Resources for Data Warehousing
Note: Setting values for PCTUSED, FREELIST, and FREELIST_
GROUPS in database objects such as tables will be ignored if the contain-
ing tablespace is set to automatic segment space management.
In past versions of Oracle Database, manual free list management
was usually only required for very highly concurrent active OLTP
databases or Oracle RAC (Parallel Server) installations. Access to the
PCTUSED parameter, on the other hand, helped immensely with
tuning for performance in the following respect. The default value for
PCTUSED is very low, at 40%. Any database with heavy deletion
activity could ...