CPU Utilization 100%

  • From: "fahd mirza" <fahd-m@xxxxxxxxxxx>
  • To: "Active DBA" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 3 Sep 2004 12:59:45 +0500

         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.
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe 
To read recent messages - http://freelists.org/archives/oracle-l/09-2004

Other related posts: