???????????????
??????????Windows???Oracle???????oracle????CPU??????????99%?????????????????????????
????????????·
???????????CPU???????????У?????????????SQL???????????衢Oracle Bug???????????????CPU???????ID??UNIX??LINUX???????ID??Windows????????????SQL????????????????
???????????????
????1. ????process explorer??????????Windows?????μ?????????????

????3. ????????????TID?????????SQL????????SQL??????????
????SELECT sql_text FROM v$sqltext a WHERE (a.hash_value?? a.address) IN (SELECT DECODE(sql_hash_value?? 0?? prev_hash_value?? sql_hash_value)??DECODE(sql_hash_value?? 0?? prev_sql_addr?? sql_address) FROM v$session b WHERE b.paddr =(SELECT addr FROM v$process c WHERE c.spid = '&pid')) ORDER BY piece ASC;
????select id??serial# ??username??osuser??machine??program??process??to_char(logon_time??'yyyy-mm-dd hh24:mi:ss') logon from v$session where paddr in ( select addr from v$process where spid in('&pid'));
????4. kill?????????????????SQL??????????????
??????????
????????е???????????????????????????TID????????в鯔???????SQL????????????????????????kill?????CPU??????????????????????AWR??ASH????????ι???????????м????漰???????????????洢?????й????洢??????????д???????????????·??????????????????????????