Re: System tablespace 97 % full

Hi Ivan,

First of all, thanks for your the respectful tone of your reply,

My issue was that the server was stuck at 100% cpu usage when a java program inserting data into the db was running.
The insertion was ways slower than before ...

My surprise was to see a 97% full system tablespace, which seemed rather abnormal to me (I ain't no dba but you surely guessed that).

I thought there was temp object created in it and left so I (badly) asked how to erase them (and find them of course).

At the end, I solved the problem which was a misconfiguration of a tool (for O/R mapping) used in that program, which made the class not use one of the index.

Kind regards,

Jerome

"Ivan Saez" <i.a.saez.scheihing_at_tue.nl> a écrit dans le message de news: 3D108F1E.E2268A4_at_tue.nl...
> 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 Thu Jun 20 2002 - 03:03:09 CDT