Re: Limiting CPU usage for a user

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: 23 Aug 2002 10:23:16 -0700
Message-ID: <ak5r2401tkj@drn.newsguy.com>

In article <3D666BB3.8EABC0F_at_exesolutions.com>, Daniel says...
>
>Richard Foote wrote:
>
>> Hi There,
>>
>> Just note that resource manager doesn't kick in with the CPU resource until
>> the CPU is seriously maxing out. Until then, all users get equal share of
>> CPU.
>>
>> Cheers
>>
>> Richard

snip
>
>From your experience does this apply to consumer groups and other means of
>controlling resource utilization?
>
>Daniel Morgan
>

AFAIK, the only part of Resource Manager that this doesn't apply to is the switching to lower resource usage groups before the query executes.

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Fri Aug 23 2002 - 12:23:16 CDT