Re: Re[2]: controlling CPU usage through Oracle
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).
Re: Re:RE: Re[2]: controlling CPU usage through Oracle
Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle Tony, No, as of now it does not have that functionality. Thanks for your input. ed - Original Message - From: Aponte, Tony To: Multiple recipients of list ORACLE-L Sent: Thursday, August 29, 2002 1:33 PM Subject: RE: Re:RE: Re[2]: controlling CPU usage through Oracle Just some thoughts. Does your OS have any domain partitioning features that you can use to create separate "servers"? You could carve out a portion of the CPU resources into a small domain and dedicate it to your problem child. The net effect would be to throttle the problem database by denying it the resources used by the others. How about using processor sets do achieve the same thing. I'm thinking along the lines of two sets, one with a very low number of CPU's. You would then bind your problem child to the small set and the rest to the other. HTH Tony Aponte
RE: Re:RE: Re[2]: controlling CPU usage through Oracle
Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle Just some thoughts. Does your OS have any domain partitioning features that you can use to create separate "servers"? You could carve out a portion of the CPU resources into a small domain and dedicate it to your problem child. The net effect would be to throttle the problem database by denying it the resources used by the others. How about using processor sets do achieve the same thing. I'm thinking along the lines of two sets, one with a very low number of CPU's. You would then bind your problem child to the small set and the rest to the other. HTH Tony Aponte
Re[2]: Re:RE: Re[2]: controlling CPU usage through Oracle
YES Reply Separator Author: "Ed Lewis" <[EMAIL PROTECTED]> Date: 8/29/2002 7:23 AM Dick and Dennis, The application here is the same, where all users are logged in as the same user via the application server. But in my case, I want to throttle all the users who use this id. Wouldn't ORM be beneficial in that situation ? thanks. ed > Dennis, > > You've got that right. Damned PeopleSoft! We were hoping we might be able > to leverage ORM to control PeopleSorft query users. No such luck since everyone > is PeopleSoft. Now on the other hand, if you've got the LUXURY of having people > logged in with their own usernames you certainly can throttle down those you > want, almost to a crawl. > dick goulet > Dick - My understanding is that Oracle Resource Manager controls resources > based on userid. In other words, if a third-party application or an > application server uses the same Oracle userid for access, then Oracle > Resource Manager wouldn't help much. Is that what you've seen? > Dennis Williams > DBA > Lifetouch, Inc. > > Ed, > > The only way your going to do this is through Oracle Resource Manager. > You'll need an 8.1.x Enterprise database. Then you can setup your resource > plans and groups to manage who gets how much CPU at a time. Any of the > operating level tools out there cannot get down to the level of granularity > your > asking for since all of the activity happens within Oracle. All those tools > can > do is control the amount of CPU that Oracle gets which has a global effect > that > hampers all users of the database. > > Dick Goulet -- 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: 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).
Re: Re:RE: Re[2]: controlling CPU usage through Oracle
Dick and Dennis, The application here is the same, where all users are logged in as the same user via the application server. But in my case, I want to throttle all the users who use this id. Wouldn't ORM be beneficial in that situation ? thanks. ed > Dennis, > > You've got that right. Damned PeopleSoft! We were hoping we might be able > to leverage ORM to control PeopleSorft query users. No such luck since everyone > is PeopleSoft. Now on the other hand, if you've got the LUXURY of having people > logged in with their own usernames you certainly can throttle down those you > want, almost to a crawl. > dick goulet > Dick - My understanding is that Oracle Resource Manager controls resources > based on userid. In other words, if a third-party application or an > application server uses the same Oracle userid for access, then Oracle > Resource Manager wouldn't help much. Is that what you've seen? > Dennis Williams > DBA > Lifetouch, Inc. > > Ed, > > The only way your going to do this is through Oracle Resource Manager. > You'll need an 8.1.x Enterprise database. Then you can setup your resource > plans and groups to manage who gets how much CPU at a time. Any of the > operating level tools out there cannot get down to the level of granularity > your > asking for since all of the activity happens within Oracle. All those tools > can > do is control the amount of CPU that Oracle gets which has a global effect > that > hampers all users of the database. > > Dick Goulet -- 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).
Re: Re[2]: controlling CPU usage through Oracle
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).
Re:RE: Re[2]: controlling CPU usage through Oracle
Dennis, You've got that right. Damned PeopleSoft! We were hoping we might be able to leverage ORM to control PeopleSorft query users. No such luck since everyone is PeopleSoft. Now on the other hand, if you've got the LUXURY of having people logged in with their own usernames you certainly can throttle down those you want, almost to a crawl. Dick Goulet Reply Separator Author: DENNIS WILLIAMS <[EMAIL PROTECTED]> Date: 8/28/2002 1:53 PM Dick - My understanding is that Oracle Resource Manager controls resources based on userid. In other words, if a third-party application or an application server uses the same Oracle userid for access, then Oracle Resource Manager wouldn't help much. Is that what you've seen? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 28, 2002 11:52 AM To: Multiple recipients of list ORACLE-L Ed, The only way your going to do this is through Oracle Resource Manager. You'll need an 8.1.x Enterprise database. Then you can setup your resource plans and groups to manage who gets how much CPU at a time. Any of the operating level tools out there cannot get down to the level of granularity your asking for since all of the activity happens within Oracle. All those tools can do is control the amount of CPU that Oracle gets which has a global effect that hampers all users of the database. Dick Goulet Reply Separator Author: "Ed Lewis" <[EMAIL PROTECTED]> Date: 8/28/2002 5:13 AM 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. 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: mailto:[EMAIL PROTECTED]"; [EMAIL PROTECTED]>Jamadagni, Rajendra To: mailto:[EMAIL PROTECTED]"; [EMAIL PROTECTED]>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 o
RE: Re[2]: controlling CPU usage through Oracle
Dick - My understanding is that Oracle Resource Manager controls resources based on userid. In other words, if a third-party application or an application server uses the same Oracle userid for access, then Oracle Resource Manager wouldn't help much. Is that what you've seen? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, August 28, 2002 11:52 AM To: Multiple recipients of list ORACLE-L Ed, The only way your going to do this is through Oracle Resource Manager. You'll need an 8.1.x Enterprise database. Then you can setup your resource plans and groups to manage who gets how much CPU at a time. Any of the operating level tools out there cannot get down to the level of granularity your asking for since all of the activity happens within Oracle. All those tools can do is control the amount of CPU that Oracle gets which has a global effect that hampers all users of the database. Dick Goulet Reply Separator Author: "Ed Lewis" <[EMAIL PROTECTED]> Date: 8/28/2002 5:13 AM 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. 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: mailto:[EMAIL PROTECTED]"; [EMAIL PROTECTED]>Jamadagni, Rajendra To: mailto:[EMAIL PROTECTED]"; [EMAIL PROTECTED]>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 PMTo: Multiple recipients of list ORACLE-LSubject: 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
RE: Re[2]: controlling CPU usage through Oracle
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 Ed, The only way your going to do this is through Oracle Resource Manager. You'll need an 8.1.x Enterprise database. Then you can setup your resource plans and groups to manage who gets how much CPU at a time. Any of the operating level tools out there cannot get down to the level of granularity your asking for since all of the activity happens within Oracle. All those tools can do is control the amount of CPU that Oracle gets which has a global effect that hampers all users of the database. Dick Goulet Reply Separator Author: "Ed Lewis" <[EMAIL PROTECTED]> Date: 8/28/2002 5:13 AM 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. 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: mailto:[EMAIL PROTECTED]"; [EMAIL PROTECTED]>Jamadagni, Rajendra To: mailto:[EMAIL PROTECTED]"; [EMAIL PROTECTED]>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-Fr
Re[2]: controlling CPU usage through Oracle
Ed, The only way your going to do this is through Oracle Resource Manager. You'll need an 8.1.x Enterprise database. Then you can setup your resource plans and groups to manage who gets how much CPU at a time. Any of the operating level tools out there cannot get down to the level of granularity your asking for since all of the activity happens within Oracle. All those tools can do is control the amount of CPU that Oracle gets which has a global effect that hampers all users of the database. Dick Goulet Reply Separator Author: "Ed Lewis" <[EMAIL PROTECTED]> Date: 8/28/2002 5:13 AM 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. 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: mailto:[EMAIL PROTECTED]"; [EMAIL PROTECTED]>Jamadagni, Rajendra To: mailto:[EMAIL PROTECTED]"; [EMAIL PROTECTED]>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 PMTo: Multiple recipients of list ORACLE-LSubject: 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'v
