Re: controlling CPU usage through Oracle

[Ed Lewis]

Raj,     Thanks for your input. From what I understand with profiles, the session will be terminated once a threshold is reached.     In this particular case, I cannot terminate the session. I need to be able to control the CPU usage of a session, without ending it.      If this cannot be done within Oracle, then maybe it can be accomplished through the OS.           thanks.                         ed                       ----- Original Message ----- From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Tuesday, August 27, 2002 4:48 PM Subject: RE: controlling CPU usage through Oracle You could use profiles to control CPU usage as well, more info is in manuals.   Raj ______________________________________________________ Rajendra Jamadagni              MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -----Original Message----- From: Ed Lewis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 4:18 PM To: Multiple recipients of list ORACLE-L Subject: controlling CPU usage through Oracle Hi,     I'm looking for a way to control CPU usage of particular queries on a database.     After exploring, and implementing ways of optimizing the code, these queries can run anywhere from 45 seconds to 2 minutes.      This database is 1 of 5 on this box. So, although it's important to build effective queries, it's also important in this environment that these queries do not impact the other 4 databases.     What I want to do is place a limit on CPU usage without terminating the query. I've looked at profiles with the "cpu_per_call" and "cpu_per_session" settings. I have never used profiles, but from what I understand, these will kill the session once they reach a threshold.     I'm also looking at database resource management. This may be more appropriate for this situation.     Has anyone used this, and if so what are you experiences ? Would you recommend it ?     Would the only way to control CPU usage on this box, be through the operating system ?   I welcome any suggestions. I appreciate your time.   The environment is Oracle 8.1.7.2, AIX 4.3.3.