Re: High CPU consumption notification

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1094602480.315319_at_yasure>...
> 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

If I have my way, my database will already be at 10g or least 9i version, on a bigger server too.......

Thanks for your feedback, Howard and Daniel. Received on Wed Sep 08 2004 - 08:48:00 CDT