Path: news.easynews.com!easynews!newshub2.home.com!news.home.com!nntp.abs.net!news.maxwell.syr.edu!diablo.theplanet.net!news.theplanet.net!not-for-mail From: "Wombat" Newsgroups: comp.databases.oracle.server Subject: Re: Oracle goes ballistic Date: Thu, 11 Oct 2001 02:12:10 +0100 Organization: Oracle Lines: 55 Message-ID: <9q2ok7$d0l$1@newsg4.svr.pol.co.uk> References: <9q2gp5$rct$1@newsg2.svr.pol.co.uk> <9q2l9r0eo0@drn.newsguy.com> Reply-To: "Wombat" NNTP-Posting-Host: modem-200.foxface.dialup.pol.co.uk X-Trace: newsg4.svr.pol.co.uk 1002759623 13333 62.137.15.200 (11 Oct 2001 00:20:23 GMT) NNTP-Posting-Date: 11 Oct 2001 00:20:23 GMT X-Complaints-To: abuse@theplanet.net X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 Xref: easynews comp.databases.oracle.server:120885 X-Received-Date: Wed, 10 Oct 2001 18:31:41 MST (news.easynews.com) Thomas Kyte wrote in message news:9q2l9r0eo0@drn.newsguy.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? Sorry, just looked at the process that was using all the CPU, I will pay more attention to the name the name next time. However, the server is a dual processor Intel box running Solaris and Oracle 8.0.5... Only one CPU gets hit and we only have one instance and Schema. I don't recall it being any of pmon,smon,dbwr,lgwr though. > > 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. I would love to know how to look in the database, find out this information. I suspect that it is caused by a query but can't see any that are complicated enough to do this. The runaway is not reproducible. What might be the best starting point to find the offending query/job perhaps Tigger? I can't execute any shutdown commands at all and all transaction processing appears to cease. Will anything get through and provide debugging information in this state? I know this is a little sketchy so please bear with me! > Thanks I will look for the process name tomorrow! > -- > 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 >