答复: 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@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
=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@xxxxxxxxxxxxx&subject=3Dunsubscribe=20
To read recent messages - http://freelists.org/archives/oracle-l/09-2004

---
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe 
To read recent messages - http://freelists.org/archives/oracle-l/09-2004

Other related posts: