PCT increase
Hi All,
I have read this explanation about PCTINCREASE storage clause in doc.oracle site as:
If you want to keep all extents the same size, you can prevent the SMON background process from coalescing extents by setting the value of PCTINCREASE to 0. In general, Oracle recommends a setting of 0 as a way to minimize fragmentation and avoid the possibility of very large temporary segments during processing.
But as we all know that SMON is the background process which is used to coalesce adjacent free space and thereby reducing fragmentation.
So how come by setting pctincrease=0,disables the smon and also minimizes the fragmenation?
BR
Sphinx