How to diagnose the high CPU utilization of ORACLE.EXE in Windows environment
Suddenlyuserscomplainsslowresponseofdatabase.Youlookattaskmanager,ORACLE.EXEistakinghighCPUalmost100%CPU.Asperyourknowledgedatabaseactivityisnormal,nonewjobsarerunning.KeentodrilldowntheOracleprocess/SQLusinghighCPU.UnlikeUNIX,OSPIDisgenericforORACLE.EXEanddoesn'trepresentser
下载地址
用户评论
虽然和实际中遇到的情况不太一样，但是很有启发，大力推荐阅读