Re: Oracle goes ballistic

Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:9q2l9r0eo0_at_drn.newsguy.com...
> In article <9q2gp5$rct$1_at_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
>
Received on Wed Oct 10 2001 - 20:12:10 CDT