I worked with a DB once, don't remember which one (may have been Oracle) that allowed query monitoring to be turned on at the DB level and you could turn it on for a week or so and it would report to you the heaviest queries taking place during its monitoring time. I seem to remember it being a bit of a performance hit...but you can't do that type of thing without impacting performance....
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Stonequist Sent: Wednesday, January 03, 2007 7:57 AM To: arslist@ARSLIST.ORG Subject: Re: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2 Thanks you Axton, Patrick, & Lars!!! We really appreciate the input so far and I've taken these suggestions to the "powers that be" for discussion!! I look forward to any other ideas that may be out there! Thank you all again!! Shawn Stonequist EMNS, Inc. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"