Re: Why tablespaces still need coalescing

From: Wilko <Wilko_at_yoa.com>
Date: 2000/03/08
Message-ID: <8a4pvg$or314@inetbws1.citec.com.au>#1/1

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