Urgent: NT 8.0.5 restarted after 76 days, now slow

From: Michael Kline <maklinesr_at_home.com>
Date: Tue, 25 Jul 2000 10:00:48 -0400
Message-Id: <10569.112871@fatcity.com>

One of my Houston customers bounced the database server this morning, and Oracle80.exe is eating up almost 90% of the server, constantly for a couple of hours now.

The database did not want to shut down normally. He finally had to kill it.

When he brought it back up, it just sucks up all sorts of CPU and queries are taking "forever" to run.

buffer cache and library cache are almost 100%, but dictionary cache is only 39%.... Running the "less than 5%" query, it's reported to be 51.98%. (It's been up for 2-3 hours now)

It's 8.0.5.0.0 on NT SP3, with 256MB memory and twin 360mhz processors.

Previously to this, the system was running just fine. Normal running is Dictionary 99, Library 99, and Buffer 89.

In 16 years I've not seen anything quite like this. Nothing has been added or changed. As I said, the database server had been up steady for over 76 days. Being NT, there is little they could add without bouncing the server.

Metalink shows nothing so far...

Anyone seen anything like this?

Michael Kline
ThinkSpark
Richmond, VA Received on Tue Jul 25 2000 - 09:00:48 CDT