I had a similar problem recently check your bdump and udump folders under
your admin directory to see if you are getting a massive amount of them. I
had a corrupt UNDO table space and every time a user was updating the
database it would create a user dump the high CPU usage was actually caused
by the massive amount of data it was writing to the dump logs.
Once I fixed the UNDO table space the dumps stopped and the CPU usage went
back to normal. I am not sure you have the same problem but I know from
experience when my CPU usage spikes on my database I always check my Oracle
log files.
Patrick McIntyre
CMRE Financial Services, Inc
Vice President - Information Technology
Direct Line: 714-982-5225
Fax: 714-528-8711
Email: [Email address protected]
Please note that the information contained in this message may be privileged
and confidential and protected from disclosure. If the reader of this
message is not the intended recipient, or an employee or agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify us by replying to the message and
deleting it from your computer. Thank you. CMRE Financial Services, Inc
-----Original Message-----
From: Fan Miao
[mailto:oracledba-ezmlmshield-x83965266.[Email address protected]
Sent: Friday, September 28, 2007 1:26 PM
To: LazyDBA Discussion
Subject: High CPU usage after database is open
Hello,
I have 3 Oracle (9.2.0.8) instances on Windows, and they are same
testing databases refreshed from one production database. Two of them
are fine, but I got problem with the 3rd. After I open this database,
the CPU is up to 100%, but without it's open, the CPU is only 20%
around. I can not find a good solution and I read everything I can find
including "Diagnosing High CPU Utilization on NT" from metelink, but I
can not identify what's caused this problem. Could anyone provide a
hint here? I really appreciate it.
Thanks a lot!
Miao
This message may contain privileged and/or confidential information.
If you have received this e-mail in error or are not the intended recipient,
you may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page