Re: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2

2007-01-03 Thread Shawn Stonequist
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.

Re: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2

2007-01-03 Thread L. J. Head
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

Re: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2

2007-01-03 Thread Hall Chad - chahal
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

Re: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2

2007-01-03 Thread Axton
: 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

Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2

2007-01-02 Thread Shawn Stonequist
Greetings List!! We have an issue in which some users (we know not who) are running queries which are affecting the performance of our Remedy system, causing significant delays, issues, and even complete system lock-ups for all our Users. We have three goals that we would like to accomplish: 1)

Re: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2

2007-01-02 Thread Axton
You can do a couple of things: - look at the remedy logs to figure out what these people are doing (sql); then take steps to stop it. - Limit the number of records the server can return (admin tool/ar.conf) Unfortunately, from the db side, there is not much you can do to stop what has started,

Re: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2

2007-01-02 Thread DILL, PATRICK A
: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2 Greetings List!! We have an issue in which some users (we know not who) are running queries which are affecting the performance of our Remedy system, causing significant delays, issues, and even complete system lock-ups

Re: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2

2007-01-02 Thread lars . j . pettersson
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Shawn Stonequist Sent: Tuesday, January 02, 2007 11:34 PM To: arslist@ARSLIST.ORG Subject: Performance Issues caused by User Queries - Remedy 6.3/Oracle 10.0.2 Greetings List!! We have an issue in which some users (we know not who