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).