Re: Why tablespaces still need coalescing

Hi,

If the pct_inrease for a tablespace is zero then coalesces can not be done automatically by Oracle.
So, you have to manually coalesces the tablespace.

Thanks.

Palani

Wilko wrote:
>
> In article <38C5E443.A40BA563_at_yahoo.com>, Leng Kaing <lkaing_at_yahoo.com> wrote:
> >Huh? Don't understand your question. What do you mean "tablespaces still
> >need coalescing"? Are you asking whether you still need to coalesce, it
> >you're still seeing that it IS coalescing without your manual
> >intervention?
> >
> >If one, I suppose to make bigger chunks of free space.
> >If two, then check your pctincrease at the tablespace level.
> I am lead to believe that if one makes all the extent sizes the same in the
> one tablespace then the tablespace will never need coalescing.
> And this allows me to set the pctincrease on the tablespace to zero which
> speeds up the database because when set to zero it no longer coalesces the
> tablespace.
>
> Wilko
> >
> >HTH,
> >Leng.
> >
> >Wilko wrote:
> >
> >> I am using oracle 7.3 and all the extents are the same size
> >> each tablespace. However, the tablespaces still need coalescing.
> >>
> >> Any ideas?
> >
  Received on Wed Mar 08 2000 - 00:00:00 CST