Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SYSTEM Tablespace is FULL

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US