Re: Oracle goes ballistic

In article <9q2ok7$d0l$1_at_newsg4.svr.pol.co.uk>, "Wombat" says...
>
>
>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.

See
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:767025833873

its a script that will dump the sql currently being executed by any active session. You can use this to see what sql is being run. Based on your other post -- the oraclelims process is a dedicated server (a backend to a client connection). Someone is running a bit of sql thats hitting you hard.

>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
>>
>
>

--
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