΄πΈ΄: CPU Utilization 100%

To find sql,u can use select sql_text from v$sql where hash_value in = (select
sql_hash_value from v$session where status=3D'ACTIVE');

-----=D3=CA=BC=FE=D4=AD=BC=FE-----
=B7=A2=BC=FE=C8=CB: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
=B4=FA=B1=ED fahd mirza
=B7=A2=CB=CD=CA=B1=BC=E4: 2004=C4=EA9=D4=C23=C8=D5 16:00
=CA=D5=BC=FE=C8=CB: Active DBA
=D6=F7=CC=E2: 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=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