Path: news.easynews.com!easynews!feed2.onemain.com!feed1.onemain.com!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!newshub2.rdc1.sfba.home.com!news.home.com!pln-w!spln!dex!extra.newsguy.com!newsp.newsguy.com!drn
From: Thomas Kyte <tkyte@us.oracle.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle goes ballistic
Date: 10 Oct 2001 16:23:39 -0700
Organization: Oracle
Lines: 29
Message-ID: <9q2l9r0eo0@drn.newsguy.com>
References: <9q2gp5$rct$1@newsg2.svr.pol.co.uk>
NNTP-Posting-Host: p-677.newsdawg.com
X-Newsreader: Direct Read News 2.90
Xref: easynews comp.databases.oracle.server:120877
X-Received-Date: Wed, 10 Oct 2001 17:09:03 MST (news.easynews.com)

In article <9q2gp5$rct$1@newsg2.svr.pol.co.uk>, "Wombat" says...
>
>Hi,
>
>Every now and then my Oracle Enterprise Server goes consumes 100% of the CPU
>for 10-15 minutes then all goes quiet.  Truss of the process reveals a
>stream of brk(xxxxxxx) system calls.  Any idea what is wrong here?
>
>Thanks in Advance
>
>Wombat
>
>
>

since you reference truss -- you are on unix.

what process are you trussing?  we are a multi-process thing.  pmon, smon, dbwr,
lgwr, dedicated server, shared server, what?

Also -- did you look IN the database to see what its doing??  Perhaps there is a
job/query that is running at that point in time.

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp