Re: System tablespace 97 % full

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Tue, 18 Jun 2002 19:05:37 +1000
Message-ID: <urDP8.14726$Hj3.48646@newsfeeds.bigpond.com>

IF you've installed the Oracle JVM option and you have no real intention of using it, you are potentially wasting a lot of space in the System tablespace. Uninstalling it could help to effectively "empty" some of the contents in the System tablespace.

Regards

Richard
"Jerome B" <jbaton_at_oxymel.com> wrote in message news:3d0ee7ab$0$239$626a54ce_at_news.free.fr...
> Hi all,
>
> The SYSTEM tablespace of a 8i DB is full at 97 %
>
> Could it be the reason why Oracle take up to 99% CPU ? (more disk swapping
> because of less disk space ?)
>
> How could I empty it ?
>
>
>
>
> my configuration is Oracle 8.1.7 on Dell P4/W2KPro
>
>
Received on Tue Jun 18 2002 - 04:05:37 CDT