Re: High CPU consumption notification

Leigh wrote:

> Oracle 8.1.7.4
> Window 2000
>
> My database server has recently encountered 100%CPU consumption by
> threads spinning on Window 2000 system. When that happened, the system
> slow down to almost complete halt.
>
> I believe I have hit the oracle bug 2960293.
>
> Since there is no fix for it at the moment, I was wondering if there
> is any alert event that I can use before my database hit this bug?
> That is, notify me before the database is running at 100%cpu
> constantly?
>
> Thanks,
> Leigh

Bug? You have a version of Oracle that begins desupport in just a matter of a few months. I think your time would be far better spent getting ready to upgrade to 9i or preferably 10g.

But until then ... try building a PROFILE for your users. http://www.psoug.org
click on Morgan's Library
click on Profiles

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)