Re: SYSTEM Tablespace is FULL

From: Ron Reidy <r_reidy_at_comcast.net>
Date: Fri, 05 Sep 2003 21:00:53 -0600
Message-ID: <3F594DE5.7060808@comcast.net>

Hmmm... you most likely have things in SYSTEM that don't belong there. You need to move them to a different TS.

What do you mean "increase the speed"? What is slow? Why is it slow? What waits are you experiencing?

Hari Om wrote:
> 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!

-- 
Ron Reidy
Oracle DBA

Received on Fri Sep 05 2003 - 22:00:53 CDT