Re: System tablespace 97 % full

Jerome,

There are three posibilities:

1. users (other than sys and system) are creating objects in the system tablespace.
2. auditing is enabled.
3. your system tablespace is just to small. Enlarge it.

Others have pointed out how to detect 1 & 2 and how to enlarge the system tablespace.
About Oracle taking up 99% of the CPU : it's difficult to say something about but I don't think it
has to do with your system tblspace being for 97% full.

kind regards,

Ivan

Jerome B wrote:

> 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 Wed Jun 19 2002 - 09:03:10 CDT