Previous Topic: Routine Database CleanupNext Topic: Database Defragmentation


NEXT and PCTINCREASE Reduction

To reduce PCTINCREASE and NEXT, alter the tables and indexes by issuing the following from within sqlplus. For very heavy encyclopedia usage, consider replacing 4M for DOBJ and DASC with higher values. The value, 4M, should be adequate if you export and import weekly. MAXEXTENTS is 99 by default, where the highest valid value is 121. Query to Reduce PCTINCREASE and NEXT:

Query to reduce PCTINCREASE and NEXT