论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2010-05-11 14:12 |只看该作者 |倒序浏览

生产环境数据库，安装在8C32G的小型机上，但是最近发现CPU利用率居高不下，一直在80%以上。已经分析过AWR的SQL，SQL基本正常，调整了一些运行时间比较长的SQL，调整后，在业务低峰期时CPU利用率也得在60%以上。
请各位高手指点一下，问题还会出在哪？

oracle本身有什么坏了，导到所在机器CPU利用率居高不下吗？

用topas看看AIXCPU使用情况如下：
Network KBPS I-Pack O-Pack KB-In KB-Out Execs 0 Namei 81
Tue May 11 13:10:06 2010 Interval: 2 Cswitch 500 Readch 274.5K
  Syscall 7193 Writech 29214
CPU User% Kern% Wait% Idle% Reads 152 Rawin 0
ALL 69.1 1.6 0.4 29.0 Writes 101 Ttyout 211
  Forks 1 Igets 0
Network KBPS I-Pack O-Pack KB-In KB-Out Execs 0 Namei 81
en1 40.6 110.6 106.6 14.4 26.1 Runqueue 6.5 Dirblk 0
lo0 0.1 1.0 1.0 0.0 0.0 Waitqueue 0.0

Disk Busy% KBPS TPS KB-Read KB-Writ PAGING MEMORY
hdisk8 0.0 24.0 4.0 4.0 20.0 Faults 1297 Real,MB 32768
hdisk2 0.0 24.0 4.0 6.0 18.0 Steals 0 % Comp 44
hdisk9 0.0 12.0 1.0 4.0 8.0 PgspIn 0 % Noncomp 9
Network KBPS I-Pack O-Pack KB-In KB-Out Execs 0 Namei 81
Tue May 11 13:10:06 2010 Interval: 2 Cswitch 444 Readch 740.7K
  Syscall 4432 Writech 29127
CPU User% Kern% Wait% Idle% Reads 280 Rawin 0
ALL 69.1 1.6 0.4 29.0 Writes 113 Ttyout 221
  Forks 3 Igets 0
Network KBPS I-Pack O-Pack KB-In KB-Out Execs 1 Namei 240
en1 40.6 110.6 106.6 14.4 26.1 Runqueue 6.5 Dirblk 0
lo0 0.1 1.0 1.0 0.0 0.0 Waitqueue 0.0
Disk Busy% KBPS TPS KB-Read KB-Writ PAGING MEMORY
hdisk8 0.0 24.0 4.0 4.0 20.0 Faults 3543 Real,MB 32768
hdisk2 0.0 24.0 4.0 6.0 18.0 Steals 0 % Comp 44
hdisk9 0.0 12.0 1.0 4.0 8.0 PgspIn 0 % Noncomp 9
hdisk4 0.0 8.0 0.0 0.0 8.0 PgspOut 0 % Client 9
  PageIn 0
Name PID CPU% PgSp Owner PageOut 7 PAGING SPACE
oracle 295000 12.8 9.2 oracle Sios 8 Size,MB 32768
oracle 217088 12.3 8.5 oracle % Used 0
oracle 336196 12.3 8.1 oracle NFS (calls/sec) % Free 100
oracle 164036 12.3 8.7 oracle ServerV2 0
oracle 397572 11.3 8.7 oracle ClientV2 0 Press:
oracle 167960 1.8 12.3 oracle ServerV3 0 "h" for help
oracle 234204 1.5 12.0 oracle ClientV3 0 "q" to quit
Signal 2 received

AIX, CPU, Oracle, AIX, CPU, Oracle