Re: Limiting CPU utilisation based on user profile

"Rich" <richardgillis_at_hotmail.com> wrote:
> The Oracle Database Administor's Guide indicates that it can "Guarantee
> certain users a minimum amount of processing resources regardless of
> the load on the system and the number of users".
>
> What we've found is that if we have one of the Analysts executing a
> large scale query and a User Interface user logs on (or at least
> attempts to), that the CPU is so busy that the User Interface does not
> respond.

If the user interface responds slowly, that may be a straight CPU starvation problem. If it doesn't respond at all, it is hard to believe that that is a straight CPU starvation problem. Trace the UI and see what it spending its time doing.

> If we kill the Analyst query, the UI then responds.

How do you know that this is due to CPU utilization, rather than because the Analyst holds locks that the UI needs?

> This seems to also be the case if we apply a Resource Manager plan,
> which allocates 90% to User Interface and 10% to Analysts

If the Analyst holds hold locks which are blocking the UI, then throttling back the Analyst CPU time is just cutting off your nose to spite your face. The UI will not run until the Analyst either finishes or gets killed, and thus making the Analyst run slower is not going to help.

> (since in the
> Resource Manager case, according to the documentation, these
> percentages are minimums).

OK, so then the UI should get 90% of the CPU, assuming it wants and can use that much of it. Can the UI use that much CPU time, or is it bottlenecked by something else?

Xho

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