Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Limiting CPU utilisation based on user profile
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