数据库服务器,P670两台,RAC,ORACLE9205,
今天早上一来发现先CPU忙,然后发现IO也异常繁忙。见下面的topas:
Kernel 10.9 |#### | Reads 2393 Rawin 0
User 49.0 |############## | Writes 1707 Ttyout 820
Wait 39.9 |############ | Forks 11 Igets 1
Idle 0.2 |# | Execs 13 Namei 457
Runqueue 4.5 Dirblk 3
Network KBPS I-Pack O-Pack KB-In KB-Out Waitqueue 0.0
en3 8704.4 2737.5 5724.0 2350.5 6353.8
en0 558.1 1693.0 1657.5 214.5 343.6 PAGING MEMORY
lo0 0.1 1.0 1.0 0.0 0.0 Faults 5468 Real,MB 8191
en1 0.0 0.0 0.0 0.0 0.0 Steals 1230 % Comp 86.7
PgspIn 0 % Noncomp 14.1
Disk Busy% KBPS TPS KB-Read KB-Writ PgspOut 0 % Client 9.1
hdisk15 100.0 1772.0 55.0 1756.0 16.0 PageIn 0
hdisk14 100.0 1401.8 129.0 1268.0 133.8 PageOut 5 PAGING SPACE
hdisk10 100.0 0.0 0.0 0.0 0.0 Sios 5 Size,MB 17536
hdisk13 100.0 1249.8 119.0 1120.0 129.8 % Used 3.1
hdisk1 4.0 24.0 5.5 0.0 24.0 NFS (calls/sec) % Free 96.8
hdisk0 3.0 24.0 5.5 0.0 24.0 ServerV2 0
hdisk2 0.5 2.0 0.5 2.0 0.0 ClientV2 0 Press:
hdisk5 0.0 0.0 0.0 0.0 0.0 ServerV3 0 "h" for help
cd0 0.0 0.0 0.0 0.0 0.0 ClientV3 0 "q" to quit
hdisk4 0.0 0.0 0.0 0.0 0.0
hdisk11 0.0 0.0 0.0 0.0 0.0
hdisk6 0.0 0.0 0.0 0.0 0.0
hdisk7 0.0 0.0 0.0 0.0 0.0
hdisk12 0.0 0.0 0.0 0.0 0.0
hdisk3 0.0 0.0 0.0 0.0 0.0
Name PID CPU% PgSp Owner
oracle 1601642 12.5 11.3 oracle
oracle 1867872 9.8 13.1 oracle
oracle 2257140 2.4 14.3 oracle
oracle 2269190 2.1 9.4 oracle
oracle 1261788 1.9 18.7 oracle
oracle 1454232 1.8 13.3 oracle
oracle 1515624 1.5 12.6 oracle
oracle 737374 1.4 13.6 oracle
oracle 884784 1.2 14.7 oracle
oracle 1405160 1.2 14.0 oracle
oracle 798788 1.1 12.6 oracle
oracle 1941552 1.0 14.0 oracle
oracle 1585270 0.9 11.0 oracle
oracle 1650880 0.9 5.4 oracle
oracle 2289850 0.9 9.8 oracle
oracle 1503310 0.8 14.1 oracle
然后发现繁忙的三块盘不正常,因为正常时都是10,11,12三块盘比较忙,lspv:
[oracle@DCMSDB_A:/home/oracle>]lspv
hdisk0 0031ad1ec92f9766 rootvg active
hdisk1 0031ad1e58754294 rootvg active
hdisk2 0031ad1e1fd5afb9 basevg active
hdisk3 0031ad1e44c3f051 basevg active
hdisk10 0031ad1efdc17cbb datavg concurrent
hdisk11 0031ad1efdc17e16 datavg concurrent
hdisk12 0031ad1efdc17f71 datavg concurrent
hdisk13 none None
hdisk14 none None
hdisk15 none None
hdisk4 0031ad1ea12d9ffd None
hdisk5 none None
hdisk6 0031ad1eed6d4687 None
hdisk7 none None
12,13,14应该是10,11,12的镜像盘。这是什么原因?
topas -P,没有发现异常的oracle进程,
Topas Monitor for host: DCMSDB_A Interval: 2 Wed Oct 25 10:58:34 2006
DATA TEXT PAGE PGFAULTS
USER PID PPID PRI NI RES RES SPACE TIME CPU% I/O OTH COMMAND
oracle 1888476 1 60 20 2646 6803 3055 0:40 6.8 0 0 oracle
oracle 1421500 1 71 20 3649 6803 3649 2:12 2.5 0 0 oracle
oracle 680102 1 62 20 2946 6803 3352 0:26 2.1 0 0 oracle
oracle 1405160 1 63 20 3649 6803 3649 2:14 2.0 0 0 oracle
oracle 2257140 1 60 20 3718 6803 3718 2:46 1.9 0 0 oracle
oracle 2269190 1 64 20 2076 6803 2404 446:30 1.8 0 0 oracle
oracle 2121834 1 64 20 2931 6803 3198 0:02 1.5 0 0 oracle
oracle 1364126 1 60 20 3399 6803 3637 0:50 1.4 0 0 oracle
oracle 860228 1 60 20 3198 6803 5102 0:50 1.4 0 0 oracle
oracle 2289850 1 62 20 2222 6803 2499 358:21 1.2 0 0 oracle
oracle 1675392 1 60 20 2590 6803 2984 0:27 0.9 0 0 oracle
oracle 1552620 1 60 20 2724 6803 3268 0:37 0.6 0 0 oracle
oracle 1499278 1 60 20 3572 6803 3977 2:56 0.6 0 0 oracle
oracle 1253444 1 61 20 2570 6803 2870 0:52 0.5 0 0 oracle
oracle 2302024 1 62 20 3513 6803 3513 3:21 0.5 0 0 oracle
oracle 2007248 1 61 20 3476 6803 3951 0:34 0.5 0 0 oracle
oracle 2355222 1 60 20 2562 6803 3101 1:16 0.5 0 0 oracle
oracle 1343710 1 60 20 3711 6803 3984 2:32 0.5 0 0 oracle
oracle 942136 1 60 20 2262 6803 2740 0:21 0.5 0 0 oracle
oracle 1191980 1 60 20 3592 6803 3592 3:21 0.4 0 0 oracle
请高手帮忙分析一下可能的原因?
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/9375/viewspace-555098/
,如需转载,请注明出处,否则将追究法律责任。