Re: best parameters for tablepsace

Bob,

The first 3 parameters are great if you've got dones of disk space. Don't set pctincrease to 1 or your disk could get quite fragmented.

It's a good idea to set pctincrease to 0. This way you don't have zillions of different sized blocks to crowd up your disk space.

If you drop a table like this, you will have a number of different sized free extents scattered on your disk. It is then much harder to fill this free space up completely without leaving wasted space.

In short, my advice is keep the extents the same size; it is much easier to look after.

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 Fri May 02 1997 - 00:00:00 CDT