System tablespace 99% full a problem?

From: <ora_lrnr_at_yahoo.com>
Date: 31 May 2005 04:23:23 -0700
Message-ID: <1117538603.478129.68080@o13g2000cwo.googlegroups.com>

Hello,

I am using Oracle 9i. I checked the tablespace usage in Enterprise manager. The system tablespace is 99% full. Is this is a problem? If it needs more space will it extend automatically?

When we create a tablespace we set the variable "MAXSIZE =<SOME VALUE>" for a tablepace. Is it the MAX_EXTENTS column in dba_tablespaces view?

07:05:02 SQL> select * from dba_tablespaces 07:07:37 2 where TABLESPACE_NAME = 'SYSTEM'; more...

TABLESPACE_NAME                BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT

MIN_EXTENTS
------------------------------ ---------- -------------- -----------

MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
----------- ------------ ---------- --------- --------- --------- ---

ALLOCATIO PLU SEGMEN
--------- --- ------

SYSTEM                               8192          65536
       1
 2147483645                   65536 ONLINE    PERMANENT LOGGING   NO

LOCAL
SYSTEM NO MANUAL 2) UNDO tablespace is also 98% full. Is it OK? No transaction is running against it now.

Orlando. Received on Tue May 31 2005 - 06:23:23 CDT