关于oracle 进程占用cpu的问题

ccipt_cloud

我的数据库服务器oracle 进程占用cpu 80%以上，使其他应用很慢，我的机器有6颗cpu,请问怎么才能降低oracle 对cpu的占有？

sshd

that's what an experienced DBA does --  if there is a simple answer to it, there is no need to hire a well paid DBA.
simple answer: find out which session/oracle process usese most of the CPU, using OEM or statspack, and understand what it does.

eygle

Two case for refer:

http://www.eygle.com/case/How.To.Capture.Problem.SQL.htm
http://www.eygle.com/case/how.to.getsql.which.cost.most.CPU.htm