SYSTEM Tablespace is FULL

[Hari Om]

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!

[KULJEET]

Re: SYSTEM Tablespace is FULL

no problem
it will automatically increase

[Mark D Powell]

Re: SYSTEM Tablespace is FULL

kuljeet_twtpl@h otmail.com (KULJEET) wrote in message news:<febbed51. 0309052004.2d6f 4f4e@posting.go ogle.com>...

no problem
it will automatically increase

Before expanding the SYSTEM tablespace you should find out what is
using it! If the list of tablespaces your listed is complete then you
need to add a temporary segment (sort) tablespace and a Rollback
Segment (rbs) tablespace unless the two other tablespaces shown server
these purposes.

The Concepts manual has a decent chapter on physical/logical database
setup.

If you are missing a temp segment TS then after creating one:
alter user username temporary tablespace temp [or whatever name you
give it, but temp or tmp are the most traditional names] for every
user other than SYS.

HTH -- Mark D Powell --