> -----Original Message-----
> From: Seema Singh [mailto:[EMAIL PROTECTED]]
>
> WHAT will be good value for PCTINCREASE Parameter at tablespace level?
> Zero,100 or 1
P.S. Forgot to mention - once you have read the White Paper 711 mentioned in my previous e-mail (Stop Defragmenting and Start Living), you should read this document from Steve Adams at his ixora website.
The document describes "automatic" coalescing of freespace by the SMON background process.
http://www.ixora.com.au/q+a/0102/21002406.htm