Just another thing to check: Fast or list threads might need to be increased. When there aren't enough threads available, a single intensive query could hold up things pretty badly on the server (my experience is on 7.5). You could take a thread log to see if they're all used up; in 7.5 you can adjust threads via the Server Admin console; don't know about 7.1 nor whether that's advisable without a change window.
David David Durling University of Georgia > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:arslist@ARSLIST.ORG] On Behalf Of D Dussie > Sent: Monday, September 17, 2012 11:17 AM > To: arslist@ARSLIST.ORG > Subject: Re: Querys that kill my system > > Hi Chris, > > We running into to this issue, ocassionally. It brings ours to crawl. > > What is your db? > > We are oracle on aix. > > 1. We know out heavy hitters, so user log help to find out who is on. Then 1 > of 3 admins help to write their queries do they are more effiecient. > 2. Precise, unix/db tool which can marry which aio/oracle process to explicit > query. We can kill to job. > 3. We are upgrading OEM ( oracle endpoint manager ) .. So this should > provide same capability as Precise. > 4. We constantly train, to prevent table search. > 5. All else bounce application. > > Hopefully this helps, > D > > __________________________________________________________ > _____________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 > www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
