Re: Tips for new DBA ?
From: <flemir_at_tdbank.ca>
Date: 1995/10/29
Message-ID: <46v34c$4ks_at_sam.inforamp.net>#1/1
Date: 1995/10/29
Message-ID: <46v34c$4ks_at_sam.inforamp.net>#1/1
In <704398888wnr_at_chaff.demon.co.uk>, Peter Moore <pt_at_chaff.demon.co.uk> writes:
- Change PCTINCREASE to zero wherever possible.
>
You shouldn't use PCTINCREASE = 0 generally if you are using Oracle 7.1.4 or later. Oracle 7.1.4. has a new feature in which tablespaces are not coalesced if pctincrease is set to zero. We learned this the hard way. We had set the PCTINCREASE parameter to 0 for all our tablespaces and found that we got a lot of fragmentation as a result.