RE: CPU Utilization 100%

From: Sonja Sehovic <sonja.sehovic_at_pbz.hr>
Date: Fri, 3 Sep 2004 11:54:02 +0200
Message-ID: <B3772712305A314CAB52855AF8F273960894A6F1@ksdcexc01.sit.pbz.hr>

We had the sam problem on AIX and Oracle 8.1.7. Check the latches.=20
In our case helped flush shared_pool.

HTH, Sonja

-----Original Message-----

From: David Kurtz [mailto:info_at_go-faster.co.uk] Sent: Friday, September 03, 2004 11:29 AM To: oracle-l_at_freelists.org
Subject: RE: CPU Utilization 100%

I assume you mean that ORACLE.EXE is consuming all the CPU. A couple of things to check:
* Is there a lot of PL/SQL being executed on the server (triggers and packaged procedures)?
* Has anti-virus software been installed? If so does it exclude the = Oracle
files?

regards

David Kurtz
Go-Faster Consultancy Ltd.

tel: +44 (0)7771 760660
fax: +44 (0)7092 348865
web: www.go-faster.co.uk

mailto:david.kurtz_at_go-faster.co.uk
Book: PeopleSoft for the Oracle DBA: http://www.psftdba.com PeopleSoft DBA Forum: http://groups.yahoo.com/group/psftdba

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of fahd mirza Sent: 03 September 2004 09:00
To: Active DBA
Subject: CPU Utilization 100%

Listers,

I am running Oracle 8.1.6 on windows 2k. The machine is Dell Poweredge 2500, and the no. of users are just under 100. The problem is = that
CPU utilization on the server has reached to 100%. I have checked and = there
are no blocking waits in the systems, there is no long operation. Please suggest me what can be the cause and what should I do? Is it due to any poorly written SQL, if it is , then how can I find it? Its in the = emergency,
I am waiting.
regards,
Fahd.
---

To unsubscribe - =
mailto:oracle-l-request_at_freelists.org&subject=3Dunsubscribe To read recent messages - http://freelists.org/archives/oracle-l/09-2004

---

To unsubscribe - =
mailto:oracle-l-request_at_freelists.org&subject=3Dunsubscribe=20 To read recent messages - http://freelists.org/archives/oracle-l/09-2004
---

To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe To read recent messages - http://freelists.org/archives/oracle-l/09-2004 Received on Fri Sep 03 2004 - 06:11:37 CDT