Re: System tablespace 97 % full

Jerome,

I'm glad you solved the problem. Probably the tools is creating temporary objects in the system tablespace.
Check what temporary tablespace the account you are using has. May be it's system. If so then change it to temp.

The tone some others replied to you was offensive. It's so easy to mock and make wild assumptions.

kind regards,

Ivan

Jerome B wrote:

> 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 Fri Jun 21 2002 - 08:43:51 CDT