Re: Limiting CPU utilisation based on user profile

"Rich" <richardgillis_at_hotmail.com> 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? !

If the "User Interface" is set to get a minimum of 90%, how do you think this would differ from what you want?

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB