> -----Original Message-----
> From: Seema Singh [mailto:[EMAIL PROTECTED]]
>
> WHAT will be good value for PCTINCREASE Parameter at tablespace level?
> Zero,100 or 1
I suppose that the current fashion is to set it at zero, and adopt a "uniform extent size" policy. What kind of objects will be contained in that tablespace? Tables? Indexes? Rollback segments? Temporary segments?
I would urge you first to read this old but classic paper:
HOW TO STOP DEFRAGMENTING AND START LIVING: THE DEFINITIVE WORD ON FRAGMENTATION
Bhaskar Himatsingka, Oracle Corporation
Juan Loaiza, Oracle Corporation
A PDF version of the document can be found here:
http://technet.oracle.com/deploy/availability/pdf/defrag.pdf
