High cpu usage in the aix System

The cpu usage of the aix system is too high. We found that the cpu usage of oracle is too high today. As long as oracle is used on the machine, it should be caused by SQL statements, it is caused by SQL statements. The specific operation is as follows: the Java code ix command topas finds that the cpu usage is too high, with an average of 94, www.2cto.com section Name pid cpu % PgSp Owner oracle 606274 6.7 18.6 oracle 1507346 6.1 18.6 oracle crsd. bin 364596 0.3 46.9 root sh 409808 0.1 0.6 root topas 737462 0.1 2.5 root topas 1413372 0.1 2.5 oracle dtgreet 110798 0.1 1.4 root oracle 659548 0.1 30.2 oracle ocssd. bi 442452 0.1 35.9 oracle 598074 0.1 12.4 oracle may be caused by a failure to release the database link according to speculation. You can use the process pid to find the specific SQL to determine the command as follows 1) log on to oracle: $ sqlplus/as sysdba; 2) query the session id www.2cto.com SQL> select ses through the process pid. sid from v $ session ses, v $ process pro where pro. spid = 606274 and ses. paddr = pro. addr; SID ---------- 1099 3) query specific information through v $ session SQL> select username, lockwait, status, machine, program from v $ session where sid = 1099; 4) use v $ session to find the specific SQL statement www.2cto.com SQL> select SQL _text from v $ SQL where hash_value in (select SQL _hash_value from v $ session where sid = 1099 ); determine whether to kill the process based on the SQL statement. If yes, kill-9 606274