在系统运行的时候总是有一块磁盘始终闪红灯,进入系统后
#topas查看总是有一块磁盘%BUSY为90%以上,
数据库版本:oracle 9.2.0.7
数据文件挂载的节点:/oradata/pcs/ 逻辑卷号lv04
#lslv -l lv04
对应的物理磁盘为hdisk9、hdisk10、hdisk11、hdisk4
在数据库运行的时候总是显示hdisk9 的%busy为90%,磁盘I/O非常突出,其它三块硬盘几乎为0%
请高手帮忙分析一下
#topas查看总是有一块磁盘%BUSY为90%以上,
数据库版本:oracle 9.2.0.7
数据文件挂载的节点:/oradata/pcs/ 逻辑卷号lv04
#lslv -l lv04
对应的物理磁盘为hdisk9、hdisk10、hdisk11、hdisk4
在数据库运行的时候总是显示hdisk9 的%busy为90%,磁盘I/O非常突出,其它三块硬盘几乎为0%
请高手帮忙分析一下
SQL> select name from v$datafile;NAME
--------------------
/data/oradata/orcl/s
ystem01.dbf/data/oradata/orcl/u
ndotbs01.dbf/data/oradata/orcl/s
ysaux01.dbf/data/oradata/orcl/u
sers01.dbf/data/oradata/orcl/e
xample01.dbf
SQL>
看看
SCHED POLICY是不是striped
DBA可能需要什么都知道
奇怪的是hdisk10、hdisk11、hdisk4 这3个盘根本就没有访问量,I/O几乎为零
下面是我在小机上的监控
# filemon -o fm.out -O all ; sleep 30 ; trcstop
系统系统打开fm.out文件
Most Active Files
------------------------------------------------------------------------
#MBs #opns #rds #wrs file volume:inode
------------------------------------------------------------------------
0.6 2 148 0 unix /dev/hd2:4429
0.1 1 15 0 PSBW_IDX1.dbf /dev/lv04:48
0.1 1 10 0 PSBW_DATA5.dbf /dev/lv04:44
0.1 16 19 0 vfs /dev/hd4:759
0.1 1 2 0 lx20354.nlb /dev/lv01:242020
0.0 1 2 0 lx60354.nlb /dev/lv01:242153
0.0 1 6 0 PSBW_IDX2.dbf /dev/lv04:55
0.0 1 6 0 PSBW_DATA2.dbf /dev/lv04:41
0.0 1 6 0 PSBW_DATA3.dbf /dev/lv04:42
0.0 2 4 0 lx1boot.nlb /dev/lv01:241825
0.0 1 2 0 PSBW_DATA4.dbf /dev/lv04:43
0.0 1 3 0 netsvc.conf /dev/hd4:810
0.0 2 4 0 lx20001.nlb /dev/lv01:241826
0.0 1 2 0 methods.cfg /dev/hd2:8386
0.0 1 2 0 ksh.cat /dev/hd2:11418
0.0 1 2 0 cmdtrace.cat /dev/hd2:11265
0.0 1 2 0 hosts /dev/hd4:788
0.0 11 2 0 passwd /dev/hd4:66
0.0 2 4 0 oraus.msb /dev/lv01:139273
0.0 9 2 0 SWservAt /dev/hd4:53
------------------------------------------------------------------------
util #rblk #wblk KB/s volume description
------------------------------------------------------------------------
1.00 109496 824 1911.4 /dev/hdisk9 Other FC SCSI Disk Drive
0.03 2721 56 48.1 /dev/hdisk0 N/A
0.02 576 1944 43.7 /dev/hdisk5 Other FC SCSI Disk Drive
0.00 224 0 3.9 /dev/hdisk10 Other FC SCSI Disk Drive
0.00 25 56 1.4 /dev/hdisk1 N/A
0.00 0 8 0.1 /dev/hdisk4 Other FC SCSI Disk Drive
------------------------------------------------------------------------
Detailed File Stats
------------------------------------------------------------------------
FILE: /unix volume: /dev/hd2 inode: 4429
opens: 2
total bytes xfrd: 606208
reads: 148 (0 errs)
read sizes (bytes): avg 4096.0 min 4096 max 4096 sdev 0.0
read times (msec): avg 0.276 min 0.002 max 40.153 sdev 3.289
lseeks: 280FILE: /oradata/pcs/PSBW_IDX1.dbf volume: /dev/lv04 (/oradata/pcs) inode: 48
opens: 1
total bytes xfrd: 122880
reads: 15 (0 errs)
read sizes (bytes): avg 8192.0 min 8192 max 8192 sdev 0.0
read times (msec): avg NaNQ min INF max 0.000 sdev NaNQFILE: /oradata/pcs/PSBW_DATA5.dbf volume: /dev/lv04 (/oradata/pcs) inode: 44
opens: 1
total bytes xfrd: 81920
reads: 10 (0 errs)
read sizes (bytes): avg 8192.0 min 8192 max 8192 sdev 0.0
read times (msec): avg NaNQ min INF max 0.000 sdev NaNQFILE: /etc/vfs volume: /dev/hd4 inode: 759
opens: 16
total bytes xfrd: 77824
reads: 19 (0 errs)
read sizes (bytes): avg 4096.0 min 4096 max 4096 sdev 0.0
read times (msec): avg 0.003 min 0.001 max 0.009 sdev 0.002FILE: /oracle/app/oracle/product/920/ocommon/nls/admin/data/lx20354.nlb volume:
/dev/lv01 (/oracle) inode: 242020
opens: 1
total bytes xfrd: 60992
reads: 2 (0 errs)
read sizes (bytes): avg 30496.0 min 100 max 60892 sdev 30396.0
read times (msec): avg 0.069 min 0.003 max 0.135 sdev 0.066FILE: /oracle/app/oracle/product/920/ocommon/nls/admin/data/lx60354.nlb volume:
/dev/lv01 (/oracle) inode: 242153
opens: 1
total bytes xfrd: 51312
reads: 2 (0 errs)
read sizes (bytes): avg 25656.0 min 100 max 51212 sdev 25556.0
read times (msec): avg 0.057 min 0.003 max 0.111 sdev 0.054
FILE: /oradata/pcs/PSBW_IDX2.dbf volume: /dev/lv04 (/oradata/pcs) inode: 55
opens: 1
total bytes xfrd: 49152
reads: 6 (0 errs)
read sizes (bytes): avg 8192.0 min 8192 max 8192 sdev 0.0
read times (msec): avg NaNQ min INF max 0.000 sdev NaNQFILE: /oradata/pcs/PSBW_DATA2.dbf volume: /dev/lv04 (/oradata/pcs) inode: 41
opens: 1
total bytes xfrd: 49152
reads: 6 (0 errs)
read sizes (bytes): avg 8192.0 min 8192 max 8192 sdev 0.0
read times (msec): avg NaNQ min INF max 0.000 sdev NaNQFILE: /oradata/pcs/PSBW_DATA3.dbf volume: /dev/lv04 (/oradata/pcs) inode: 42
opens: 1
total bytes xfrd: 49152
reads: 6 (0 errs)
read sizes (bytes): avg 8192.0 min 8192 max 8192 sdev 0.0
read times (msec): avg NaNQ min INF max 0.000 sdev NaNQFILE: /oracle/app/oracle/product/920/ocommon/nls/admin/data/lx1boot.nlb volume:
/dev/lv01 (/oracle) inode: 241825
opens: 2
total bytes xfrd: 40680
reads: 4 (0 errs)
read sizes (bytes): avg 10170.0 min 48 max 20292 sdev 10122.0
read times (msec): avg 0.023 min 0.004 max 0.041 sdev 0.018FILE: /oradata/pcs/PSBW_DATA4.dbf volume: /dev/lv04 (/oradata/pcs) inode: 43
opens: 1
total bytes xfrd: 16384
reads: 2 (0 errs)
read sizes (bytes): avg 8192.0 min 8192 max 8192 sdev 0.0
read times (msec): avg NaNQ min INF max 0.000 sdev NaNQFILE: /etc/netsvc.conf volume: /dev/hd4 inode: 810
opens: 1
total bytes xfrd: 12288
reads: 3 (0 errs)
read sizes (bytes): avg 4096.0 min 4096 max 4096 sdev 0.0
read times (msec): avg 0.004 min 0.002 max 0.006 sdev 0.002FILE: /oracle/app/oracle/product/920/ocommon/nls/admin/data/lx20001.nlb volume:
/dev/lv01 (/oracle) inode: 241826
opens: 2
total bytes xfrd: 11536
reads: 4 (0 errs)
read sizes (bytes): avg 2884.0 min 100 max 5668 sdev 2784.0
read times (msec): avg 0.004 min 0.003 max 0.005 sdev 0.001FILE: /usr/lib/security/methods.cfg volume: /dev/hd2 inode: 8386
opens: 1
total bytes xfrd: 8192
reads: 2 (0 errs)
read sizes (bytes): avg 4096.0 min 4096 max 4096 sdev 0.0
read times (msec): avg 0.003 min 0.002 max 0.005 sdev 0.002
lseeks: 40FILE: /usr/lib/nls/msg/en_US/ksh.cat volume: /dev/hd2 inode: 11418
opens: 1
total bytes xfrd: 8192
reads: 2 (0 errs)
read sizes (bytes): avg 4096.0 min 4096 max 4096 sdev 0.0
read times (msec): avg 0.006 min 0.003 max 0.009 sdev 0.003
lseeks: 5FILE: /usr/lib/nls/msg/en_US/cmdtrace.cat volume: /dev/hd2 inode: 11265
opens: 1
total bytes xfrd: 8192
reads: 2 (0 errs)
read sizes (bytes): avg 4096.0 min 4096 max 4096 sdev 0.0
read times (msec): avg 0.005 min 0.005 max 0.005 sdev 0.000
lseeks: 8FILE: /etc/hosts volume: /dev/hd4 inode: 788
opens: 1
total bytes xfrd: 8192
reads: 2 (0 errs)
read sizes (bytes): avg 4096.0 min 4096 max 4096 sdev 0.0
read times (msec): avg 0.004 min 0.002 max 0.005 sdev 0.002FILE: /etc/passwd volume: /dev/hd4 inode: 66
opens: 11
total bytes xfrd: 8192
reads: 2 (0 errs)
read sizes (bytes): avg 4096.0 min 4096 max 4096 sdev 0.0
read times (msec): avg 0.004 min 0.003 max 0.005 sdev 0.001
lseeks: 22FILE: /oracle/app/oracle/product/920/rdbms/mesg/oraus.msb volume: /dev/lv01 (/o
racle) inode: 139273
opens: 2
total bytes xfrd: 1536
reads: 4 (0 errs)
read sizes (bytes): avg 384.0 min 256 max 512 sdev 128.0
read times (msec): avg 0.004 min 0.003 max 0.005 sdev 0.001
lseeks: 4FILE: /etc/objrepos/SWservAt volume: /dev/hd4 inode: 53
opens: 9
total bytes xfrd: 796
reads: 2 (0 errs)
read sizes (bytes): avg 398.0 min 328 max 468 sdev 70.0
read times (msec): avg 0.003 min 0.002 max 0.004 sdev 0.001
lseeks: 1