Re: Space Problem

From: Aamer Janjua <ajfujitsu_at_hotnmail.com>
Date: Fri, 21 Mar 2003 17:26:34 +0000
Message-ID: <3E7B4B4A.10006_at_hotnmail.com>


Hi

   You can change the pct_increase as you think is fine.

In AR every table has lot of indexes on different fields..

We look after 6 different erp system on different 11i versions.. In all system our ar index is nearly double the size of ar data... so its not strange.. just relax its the nature of the beast..

I hope it helps.

Mahesh Hardikar wrote:
> Hi all ,
>
> I am facing some strange issue here.
>
> Oracle Apps 11.5.5
> Oracle Database 8.1.7.1 (32 Bit) on HP-UX 11.0 (64 Bit)
>
> While monitoring space growth I am observing Index tablespaces are
> growing at higher pace than corresponding Data tablespaces. e.g.
>
> AR_Data Tablespace Avg Growth 1.8 MB per day
> AR_Ind Tablespace Avg Growth 3 MB per day.
>
> I have noticed from dba_tablespaces that PCT_INCREASE is 50 for all
> tablespaces. Is it default ? So all objects must have been created
> with same parameter. What if I change this ?
>
> regards,
> Mahesh Hardikar
Received on Fri Mar 21 2003 - 18:26:34 CET

Original text of this message