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

Home -> Community -> Usenet -> c.d.o.server -> Re: 100% CPU on Startup and Shutdown

Re: 100% CPU on Startup and Shutdown

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 06 Jun 2005 23:26:29 -0700
Message-ID: <1118125602.396826@yasure>


opus wrote:
> Hello...
>
> Oracle 8.1.7 on Win2k-Serv SP2 P3-1.2 1GB RAM. Lots of freespace on all
> partitions.
>
> This database has been working flawlessly for several years. Recently I had to
> turn off the computer to swap the UPS. Upon restarted the server the Oracle
> instance now goes to 100% CPU usage on instance startups and shutdowns,
> dramatically slowing down the process. Instance startup takes upwards of 10
> minutes. This happens whether using DBA Studio or oradim. I suspect there may
> be slowing down during redo log switches, too.
>
> No other changes to the database that I'm aware of. The server has been
> rebooted several times in the past without incident.
>
> I'm not very experienced as a DBA, so please forgive me if I ask a silly
> question or two.
>
> Windows event logs and oracle logs are clean, though I admit I may not be
> looking everywhere or reading them correctly. I'm guessing the first thing
> might be get new memory.
>
> It's a mission critical business database, so I'm very concerned. Any
> suggestions?
>
> Thx,
> D.

Likely a Windows problem.
If it is Oracle then are you patched to 8.1.7.4? And do keep in mind your software is now in desupport mode running on the worst possible operating system (well other than Win95).

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Jun 07 2005 - 01:26:29 CDT

Original text of this message

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