Re: limit user CPU usage

Thanks, Ron, I will try it.

Kevin Wang

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> 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

>>> kwang_at_vivonet.com 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: RROGERS_at_galottery.org

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: ListGuru_at_fatcity.com (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: kwang_at_vivonet.com

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: ListGuru_at_fatcity.com (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).