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"
