Re: SYSTEM Tablespace is FULL

You provided insufficient information . You can look in the catalog at dba_data_files (I think) to see if the files for these tablespaces grow/extend automatically.

I don't see how you can connect "speed" with "size" ?

Your system tablespace seems unusually large and this could be from several things including (at least in 8i and older):

1. Putting non-system objects(that's tables and indexes mainly) into the system tablespace. Not good.
2. Some app that duplicates its unusually large data model. Not good.
3. A LOT of Plsql . Ok.
4. You have auditing turned on and are logging into the default location which is the system tablespace. Not good.

I haven't done much with 9i yet, so the 4 reasons above might not be correct for 9i.

-- 
"Hari Om" <hari_om_at_hotmail.com> wrote in message
news:d1d5ebe4.0309051405.56aca3e5_at_posting.google.com...


> I am using Oracle 9.2.0.1 on IBM AIX 5.1L

>

> My following Tablespaces are 99% full....is it normal...? do I need to

> increase manually or is ti done automatically:

> --------------------------------------------------------- 

> TABLESPACE           SIZE           USED           %USED

> --------------------------------------------------------- 

> SYSTEM               400MB          394MB            98

> EXAMPLE              138MB          137MB            99

> XDB                   38MB           37MB            99

> --------------------------------------------------------- 

>

> Do you think increasing the above Tablespace will increase the speed

> also?

>

> Any related informaiton is appreciated.

>

> (Apologize for my ignorance)

> THANKS!