Re: System tablespace is nearly full

Since you have AUTOEXTEND enabled on the SYSTEM tablespace you shouldn't need to do anything to it. If it needs to grow, it will. If you aren't using auditing in your database, the AUD$ table will be empty. You need the rollback seg in your SYSTEM tablespace for those times when the UNDO tablespace may be offline but transactions need to occur. Don't touch it.

HTH td

kpipeg wrote:
> Hi folks,
>
> Before start, I am a Unix admin but one month ago Iīve received an
> open runing production Oracle DB - 9.2 to take care off ;-)
>
> Well, Iīve seen that the SYSTEM tablespace is at 98%.
> It is configured AUTOEXTEND and the AUD$ table is empty (although
> allocated in SYSTEM). There arenīt any objects apart of those
> generated by installation.
> The current tablespace syze is 310MB
>
> Is it better to add a file or just leave it as it is?
> Would this produce poor db performance?
> Is there any avrge size for the System tablespace? Our db is not so
> big +- 100GB
>
> BTW - We have a rollback segment in the system tablespace but we are
> using the UNDOTB - and in my understanding shouldnīt affect.
>
> Thanks in advance,
>
> K PIPE G
Received on Mon Jul 05 2004 - 13:19:26 CDT