Have you opened the DB's in a different order just to see if you have the
same issue with the same DB or whether the problem moves to the last DB
being opened. It could just be your running out of resources on that server.
M.
-----Original Message-----
From: Fan Miao
[mailto:oracledba-ezmlmshield-x83965266.[Email address protected]
Sent: 28 September 2007 21:26
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
**********************************************************************
This e-mail is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it
and do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ
AccuRead Limited Registered Number: 3076187 England
GSL UK Limited Registered Number: 3333860 England
Global Solutions Limited Registered Number: 3189802 England
**********************************************************************
Oracle LazyDBA home page