Re: pctincrease = 0 or pctincrease = 1 is better?

Huy Vu wrote:
>
> Hi all,
>
> Our oracle database 8iv2 8.1.6 was created with pctincrease = 1. The
> 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

pct increase of 1 is bad, bad news..

Your tablespaces should be LOCALLY managed (a new 8i feature) which will alleviate the vast majority of tablespace internal issues..

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse