In NT and win2000 you can set Os priorities to the different tasks. If you have the sane facility on aix you can give this db a lower priority so whenever the other databases will need CPU they will get it.
Yechiel Adar Mehish ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, August 29, 2002 3:48 PM > Kevin, > Thanks for your input. > Just to clarify; I only want to control this > one database. I want to limit its resources > so it does not impact the other 4 databases on > the box. So, in that case would resource > manager be beneficial ? > Also, besides profiles, and resource manager, > does anyone know of any other tools provided > by Oracle which would limit resources ? > Or, any 3rd party tools that my be beneficial ? > > I thank everyone for providing their input; > it's much appreciated. > > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, August 28, 2002 5:23 PM > > > I don't think Resource Manager is going to do the trick here (I just read > about it over the last week while preparing for OCP exam 4). Resource > Manager would work great for a single database but Ed is trying to divvy up > resources between 5 databases. > > I don't have any good solution. I suppose if everything running on this one > database was less important than anything on the other 4 databases, you > could renice the one database. I think that would be ok provided all > components of the one database were at the same nice level. > > Kevin Kennedy > First Point Energy Corporation > > If you take RAC out of Oracle you get OLE! What can this mean? > > -----Original Message----- > Sent: Wednesday, August 28, 2002 9:52 AM > To: Multiple recipients of list ORACLE-L > > -----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. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ed Lewis > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).