Re: System tablespace 99% full a problem?

From: tina london <tinalondon_at_demon.co.uk>
Date: Tue, 31 May 2005 13:16:11 +0100
Message-ID: <d7hkik$o8j$1$8300dec7@news.demon.co.uk>

<ora_lrnr_at_yahoo.com> wrote in message
news:1117538603.478129.68080_at_o13g2000cwo.googlegroups.com...
> Hello,
>
> 1) 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.
>

check the data-dictionary to see if autoextend is on for system tablespace. see docn for further details. Received on Tue May 31 2005 - 07:16:11 CDT