Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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):
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...Received on Sat Sep 06 2003 - 02:50:44 CDT
> 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!