Re: pctincrease 0 or pctincrease 1 is better?

        If all of the objects in each of your tablespaces have uniform sizing you should change PCTINCREASE to 0, otherwise - provided that PCTINCREASE for your tablespaces is not zero - leave tham at one.

        A nonzero pctincrease of a tablespace "tells" SMON to coalesce the tablespace if possible. A zero value "tells" SMON not to coalesce. If all objects in a tablespace are of uniform size there is no need to coalesce. If they aren't they should be. ;-)

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 6/15/00, 9:58:59 PM, "Huy Vu" <huyv_at_usa.net> wrote regarding pctincrease = 0 or pctincrease = 1 is better?:

> Hi all,
 

> Our oracle database 8iv2 8.1.6 was created with pctincrease = 1. T
 he
> result after running Oracle Expert program tell us the value of
 pctincrease
> should be changed from 1 to 0.
 

> I've never worked with pctincrease = 1 so I'm confusing now.
 

> Which value should I set for pctincrease will be better?
 

> Thanks in advance for any help.
 

> H.V
Received on Fri Jun 16 2000 - 00:00:00 CDT