Re: CPU Utilization 100%

oracle-l-bounce_at_freelists.org wrote on 09/03/2004 12:59:45 AM:
> 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.
> ---

How long has the box been up?

Memory leaks tend to stress the server. Had to bounce one just the other day. Suspected memory leaks, but didn't check.

Utilization was drastically reduced following the reboot.

Typical Windoze panacea I realize. :)

Jared

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/