warning: aiowait timed out 2 times tue aug 26 15:33:32 2003 warning: aiowait timed out 2 times tue aug 26 15:33:34 2003 warning: aiowait timed out 2 times tue aug 26 15:33:36 2003 warning: aiowait timed out 2 times tue aug 26 15:33:38 2003 warning: aiowait timed out 2 times tue aug 26 15:33:43 2003 warning: aiowait timed out 1 times tue aug 26 15:33:46 2003 warning: aiowait timed out 1 times tue aug 26 15:33:49 2003 warning: aiowait timed out 1 times tue aug 26 15:33:51 2003 warning: aiowait timed out 1 times tue aug 26 15:33:52 2003 warning: aiowait timed out 1 times tue aug 26 15:33:53 2003 warning: aiowait timed out 1 times .............
我們知道在sun的某些版本上異步io存在問題 而異步io缺省是打開的
sql> show parameter disk_a
name type value ------------------------------------ ----------- ------------------------------ disk_asynch_io boolean true
針對此問題，我們停用了數據庫的異步io寫入。
2.共享內存問題
alert文件中還記錄了以下錯誤信息:
tue aug 26 21:37:40 2003 warning: einval creating segment of size 0x0000000190400000 fix shm parameters in /etc/system or equivalent
該信息說明內核參數設置過小或者和sga不匹配
我們檢查system配置文件
$ cat /etc/system ....................... set shmsys:shminfo_shmmax=4096000000 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmmni=200 set shmsys:shminfo_shmseg=200 set semsys:seminfo_semmap=1024 set semsys:seminfo_semmni=2048 set semsys:seminfo_semmns=2048 set semsys:seminfo_semmnu=2048 set semsys:seminfo_semume=200 set semsys:seminfo_semmsl=2048
我們發現最大共享內存設置僅有4g
3.檢查sga設置
sql*plus: release 9.2.0.3.0 - production on 星期二 8月 26 21:46:35 2003
copyright (c) 1982, 2002, oracle corporation. all rights reserved.
connected to: oracle9i enterprise edition release 9.2.0.3.0 - 64bit production with the partitioning, olap and oracle data mining options jserver release 9.2.0.3.0 - production
sql> show sga
total system global area 6695660272 bytes fixed size 740080 bytes variable size 2399141888 bytes database buffers 4294967296 bytes redo buffers 811008 bytes
我們發現sga設置接近7g，這也就是步驟2中錯誤提示出現的原因
4.交換區問題
我們用top工具檢查系統運行狀況
# /usr/local/bin/top
last pid: 16899; load averages: 0.82, 0.81, 0.83 21:49:05 1230 processes:1228 sleeping, 1 running, 1 on cpu cpu states: 50.1% idle, 7.4% user, 8.6% kernel, 33.9% iowait, 0.0% swap memory: 8192m real, 118m free, 12g swap in use, 11g swap free
