Re: Responsiveness of Server at high CPU load

From: Keith Jamieson <keith_jamieson_at_hotmail.com>
Date: Thu, 18 Dec 2003 11:13:14 -0000
Message-ID: <iZfEb.1328$HR.3904@news.indigo.ie>

Using Resource Limits is not avoiding the problem. You are detecting a likely problem before it has any adverse affects on the system. Prevention is always better than cure. If somebody complains, you can ask to see exactly what SQL they were running , put it through explain plan, and highlight any error, eg Cartesian Products probably being the most common. Ask the developer/contractor exactly what he is trying to achieve and then point thjem in the right direction by suggesting the most appropriate tools, built-in packages, or even suggesting a redesign.

Keith Jamieson

"Rick Denoire" <100.17706_at_germanynet.de> wrote in message news:2ts1uvogq563dujuqmse7nn4dhm8gkjghq_at_4ax.com...
> Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl> wrote:
>
>
> >You can set up resource limits. If the query is hitting the resource
> >limits it will simply be aborted.
>
> You mean setting up a profile with a limit in CPU and/or session time
> consumption? This was my first idea. I am just afraid someone will
> complain and then I will be the culprit, even If I am rather avoiding
> the problem.
>
> Bye
> Rick Denoire
Received on Thu Dec 18 2003 - 05:13:14 CST