RE: limit user CPU usage
If you are using 8i , you can setup Resource Manager. For more info about this subject see Oracle Administrator´s Guide. HIH, Antonio Belloni Carle, William TTo: Multiple recipients of list ORACLE-L (Bill), [EMAIL PROTECTED] ALINF cc: [EMAIL PROTECTED]Subject: RE: limit user CPU usage om Sent by: root@fatcity. com 15/01/02 16:30 Please respond to ORACLE-L Hi, You can set up a profile to set resource limits and have the user use that profile. This is explained in the Oracle Administrator's Guide. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, January 15, 2002 12:10 PM To: Multiple recipients of list ORACLE-L Hi, Guys, Is there some parameters or user-profile prometers in Oracle can limit user CPU usage? I mean, make specific user or all users use less CPU, I has a SQL query that use 100% CPU. I know the SQL is bad, but before developer change it, Is there something I can do? Any suggestion will be highly appreciated. My environment is Oracle8.1.6 on Win2000. Thanks, Kevin Wang -- 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: limit user CPU usage
Kevin, You can also use Resource manager to limit the CPU usage on certain user groups . It's pretty cool. HTH - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 15, 2002 1:42 PM Thanks, Ron, I will try it. Kevin Wang - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 15, 2002 11:55 AM Kevin, You could try creating a profile with the cpu_per_call and cpu_per_session set ta a particular value. It will limit the amount of time in hundredths of a second to the user assigned to the profile. I woul experiment with the values before I assigned it to a user. The manual does not say it will act as a choke on cpu usage other than time. ROR mª¿ªm [EMAIL PROTECTED] 01/15/02 01:10PM Hi, Guys, Is there some parameters or user-profile prometers in Oracle can limit user CPU usage? I mean, make specific user or all users use less CPU, I has a SQL query that use 100% CPU. I know the SQL is bad, but before developer change it, Is there something I can do? Any suggestion will be highly appreciated. My environment is Oracle8.1.6 on Win2000. Thanks, Kevin Wang -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: kevin wang 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: Sona 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: limit user CPU usage
Hi, You can set up a profile to set resource limits and have the user use that profile. This is explained in the Oracle Administrators Guide. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- From: kevin wang [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 15, 2002 12:10 PM To: Multiple recipients of list ORACLE-L Subject: limit user CPU usage Hi, Guys, Is there some parameters or user-profile prometers in Oracle can limit user CPU usage? I mean, make specific user or all users use less CPU, I has a SQL query that use 100% CPU. I know the SQL is bad, but beforedeveloper change it, Is there something I can do? Any suggestion will be highly appreciated. My environment is Oracle8.1.6 on Win2000. Thanks, Kevin Wang
Re: limit user CPU usage
Kevin, You could try creating a profile with the cpu_per_call and cpu_per_session set ta a particular value. It will limit the amount of time in hundredths of a second to the user assigned to the profile. I woul experiment with the values before I assigned it to a user. The manual does not say it will act as a choke on cpu usage other than time. ROR mª¿ªm [EMAIL PROTECTED] 01/15/02 01:10PM Hi, Guys, Is there some parameters or user-profile prometers in Oracle can limit user CPU usage? I mean, make specific user or all users use less CPU, I has a SQL query that use 100% CPU. I know the SQL is bad, but before developer change it, Is there something I can do? Any suggestion will be highly appreciated. My environment is Oracle8.1.6 on Win2000. Thanks, Kevin Wang -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: limit user CPU usage
Thanks, Ron, I will try it. Kevin Wang - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 15, 2002 11:55 AM Kevin, You could try creating a profile with the cpu_per_call and cpu_per_session set ta a particular value. It will limit the amount of time in hundredths of a second to the user assigned to the profile. I woul experiment with the values before I assigned it to a user. The manual does not say it will act as a choke on cpu usage other than time. ROR mª¿ªm [EMAIL PROTECTED] 01/15/02 01:10PM Hi, Guys, Is there some parameters or user-profile prometers in Oracle can limit user CPU usage? I mean, make specific user or all users use less CPU, I has a SQL query that use 100% CPU. I know the SQL is bad, but before developer change it, Is there something I can do? Any suggestion will be highly appreciated. My environment is Oracle8.1.6 on Win2000. Thanks, Kevin Wang -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: kevin wang 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).