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