Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Limiting CPU utilisation based on user profile

Re: Limiting CPU utilisation based on user profile

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 12 Dec 2005 10:14:47 -0800
Message-ID: <1134411283.453394@jetspin.drizzle.com>


Rich wrote:
> Help - I've got an Enterprise Edition database (9i) where we have two
> types of user; User Interface-based and Analyst-based. I'd like to use
> something (e.g., Resource Manager) to ensure that Analysts get 100% of
> CPU unless the User Interface users want to do something, at which
> time, the Analysts reduce to, say 10% of CPU.
>
> I've looked into Resource Manager and Profiles, but it suggests that I
> can only set a minimum CPU percentage, I'd rather set a maximum? Anyone
> got anything similar? !
>
> Thanks, Rich

Wht in the documentation makes you think it is possible to set a minimum?

What do you think Oracle is doing? Killing connections if you don't use a certain amount of CPU?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Dec 12 2005 - 12:14:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US