Re: 30 Character Limit

From: Sigrid Ehrenreich <Sigrid.Ehrenreich_at_carus-it.com>
Date: Tue, 18 Feb 2003 13:36:46 +0100
Message-ID: <3E5228DE.2080404@carus-it.com>

Regarding your smon question:
I have heard that some people have started to use pctincrease 1 on their tables to get the smon to coalesce free space. This is not necessary, because as far as I know, contigous free space will be coalesced when it's needed, independent of your pctincrease. Only if you set your pctincrease to something higher than 0, smon will constantly coalesce the space.

Yours Sigrid

Harish schrieb:
> Hi,
>
>
> My Apologies if the question sounds a bit silly. I need to know the
> following
>
> 1. Oracle imposes 30 character limit on object names. Any specific
> reasons why this limit has not been relaxed even in 9i.
>
> 2. SMON only coalesces contingous free extents when the pctincrease is
> set to non-zero value.
> What is the reason for this ?
>
> TIA,
>
> Hari
Received on Tue Feb 18 2003 - 06:36:46 CST