I have seen something similar to this where web service client was repeatedly making calls to a web service ... Apparently stuck in a loop of some kind. These requests were coming in so quickly that is basically amounted to a dos attack against remedy (it brought the arplugin server down quickly, and after a while it brought the whole arsystem to its knees)
In that case we figured it out by watching the API log and noticing that all the requests were coming from midtier for a specific user. Might be worth checking that out if it's a possibility in your environment. Andrew On Thursday, February 27, 2014, Dee <[email protected]> wrote: > Hello List, > > Production -- 6.1.7 UNIX with ARS 7.5 Patch 4 on Oracle 11.2.0.3, all > local. > > the server/app/db can handle the load. the issue is that we are consuming > 80% entitlement. > > Yesterday, our application hosting group reported high cpu utilization on > server. we have 2 cpu entitlement, 12 gb. > > the weird part: > user A , yesterday ran this query = SELECT > C1,C4,C3,C1,C600000046,C600000000 FROM T72 WHERE C1 IN ('004338508') > > - but the query is now in a loop. it seems that as the user that is > running the query logout/timeout, the query captures the next incoming user > to execute. > > the dba cannot kill that process, because it the run/executing and close - > very fast. So the issue is not a hung query against the DB. However, they > kill some other processes, that seem to have eliminated the respawn of that > query. I'm waiting on the dba to tell us what he saw/tried killing - that > resulted in stopping the loop. > > per the dba , that query has ran 40,000 times against the db. The current > user that has been logged - the query has executed 19,000 times with that > id. > > what cause the query to go into a loop? > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > "Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
