RE: CPU Utilization 100%

From: David Kurtz <info_at_go-faster.co.uk>
Date: Fri, 3 Sep 2004 10:29:14 +0100
Message-ID: <CKEAJBMGFEOCDBFILPJDEEDAEKAA.info@go-faster.co.uk>

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=unsubscribe
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 - 04:25:10 CDT