Re: SYSTEM Tablespace is FULL

From: Snid <snid_at_snider.sno>
Date: Mon, 8 Sep 2003 09:59:30 +1000
Message-ID: <bjggp3$mo9$1@bunyip.cc.uq.edu.au>

If auditing is turned on, then it is possible that your

SYS.AUD$ table is growing and since this is in the SYSTEM tablespace it could be responsible for it's size.

"Hari Om" <hari_om_at_hotmail.com> wrote in message news:d1d5ebe4.0309051405.56aca3e5_at_posting.google.com...
| 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!
Received on Sun Sep 07 2003 - 18:59:30 CDT