High CPU consumption notification

From: Leigh <leighlhg_at_hotmail.com>
Date: 7 Sep 2004 10:26:42 -0700
Message-ID: <b8cf9ab1.0409070926.4462c5cf@posting.google.com>

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 Received on Tue Sep 07 2004 - 12:26:42 CDT