Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Urgent: NT 8.0.5 restarted after 76 days, now slow

Re: Urgent: NT 8.0.5 restarted after 76 days, now slow

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 25 Jul 2000 15:37:54 -0400
Message-Id: <10569.112926@fatcity.com>


Sounds like there was long running process that was active during the = "shutdown abort" command and it is in the process of rolling back what was = aborted. It could take many hours..about the same time it took to create = the rollback data. Check your V$ROLLSTAT for rollback segment comsumption. Ron Rogers
DBA
Atl.GA

>>> maklinesr_at_home.com 07/25/00 11:07AM >>>
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
804-744-1545

--=20
Author: Michael Kline
  INET: maklinesr_at_home.com=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jul 25 2000 - 14:37:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US