- 论坛徽章:
- 0
|
数据库oracle10.0.1+系统aix5.3+hacmp 系统运行2年来,最近一个月来,oracle的cpu利用率一直居高不下。不知道什么原因
Topas Monitor for host: dataserver1 EVENTS/QUEUES FILE/TTY
Tue Feb 21 08:57:37 2012 Interval: 2 Cswitch 673 Readch 77504
Syscall 2624 Writech 128.0K
CPU User% Kern% Wait% Idle% Reads 192 Rawin 0
cpu2 93.6 0.4 0.0 5.9 Writes 218 Ttyout 839
cpu3 89.4 0.9 0.0 9.7 Forks 0 Igets 0
cpu0 79.3 1.0 0.1 19.7 Execs 0 Namei 3
cpu1 78.3 0.5 0.0 21.3 Runqueue 5.5 Dirblk 0
Waitqueue 0.0
Network KBPS I-Pack O-Pack KB-In KB-Out
en0 132.5 333.0 147.0 59.2 73.3 PAGING MEMORY
en2 49.1 123.5 69.0 8.8 40.3 Faults 5 Real,MB 15744
lo0 0.2 2.0 2.0 0.1 0.1 Steals 0 % Comp 43.3
PgspIn 0 % Noncomp 56.6
Disk Busy% KBPS TPS KB-Read KB-Writ PgspOut 0 % Client 56.6
hdisk2 1.5 70.0 12.0 28.0 42.0 PageIn 7
hdisk0 0.0 0.0 0.0 0.0 0.0 PageOut 10 PAGING SPACE
hdisk1 0.0 0.0 0.0 0.0 0.0 Sios 17 Size,MB 16384
cd0 0.0 0.0 0.0 0.0 0.0 % Used 5.5
NFS (calls/sec) % Free 95.5
Name PID CPU% PgSp Owner ServerV2 0
oracle 958658 18.2 10.0 oracle ClientV2 0 Press:
oracle 1941714 15.4 9.9 oracle ServerV3 0 "h" for help
oracle 3575982 14.8 10.0 oracle ClientV3 0 "q" to quit
oracle 1339422 10.8 10.0 oracle
oracle 1372168 9.5 9.7 oracle
oracle 1970218 5.5 10.0 oracle
oracle 2347174 4.7 9.8 oracle
oracle 2691326 3.3 10.2 oracle
oracle 2306216 2.8 9.8 oracle
oracle 1020078 0.2 10.3 oracle
topas 3113096 0.1 3.1 root
topas 2781358 0.1 3.1 root
hats_rs2 1806484 0.0 1.9 root
oracle 2293988 0.0 11.2 oracle
aioserve 528512 0.0 0.4 root
oracle 3612744 0.0 7.8 oracle
hats_nim 1765474 0.0 1.9 root
pnsd 204904 0.0 0.5 root
clstrmgr 409620 0.0 5.2 root
oracle 3686440 0.0 9.0 oracle |
|