Re: best parameters for tablepsace

From: <uday.v.lad_at_att.com>
Date: 1997/05/01
Message-ID: <01bc5630$01707f20$48362c87@sap06.bsi.att.com>#1/1

hi !
pctincrease 1 is batter as SMON colasce tablespace when it is fragmented. keep max extents unlimited but max size should be controlled by the limit of your hard disk device.
other wise seems ok.

UDAY
ulad_at_att.com

Bob Yeh <tyeh_at_csc.com> wrote in article <33676313.5DD1_at_csc.com>...
> Hi,
>
> Most people I have seen set the tablespace pctincrease to 0, 1 or
> 50(default) or 100. They all have their own pros and cons.
>
> With the new features of 7.3, I want to set
> autoextend on,
> maxsize unlimited,
> maxextents unlimited,
> pceincrease 1.
>
> Is this a good choice? What are the things need to watch out for?
>
> Thanks.
> Bob
>
Received on Thu May 01 1997 - 00:00:00 CDT