目前我们遇到一个棘手的问题, CPU负载几乎每隔一段时间(5分钟左右)开始升高, 有时候甚至升到16.20 , 应该属于极不正常的现象, 而且我们发现归档比原来频繁(原来12分钟左右一个, 现在2~8分钟不等归一个档), 请问我们是否需要调大redo log文件的大小(原来大小为15m), 太大的redo log是否会影响到系统性能 ??? 我都快烦死了, 各位有什么经验??
还有, 这种现象是偶尔出现的,应用程序方面基本没有太大的改变, 但是归档太频繁, 18 root 25 0 0 0 0 RW 99.9 0.0 4968m kswapd 出现的时候,负载会升高, 而且总是排在第一位, CPU占用总是85%以上 。 但是其他相同数据库我们没有发现这种现象(kswapd一般不会出现) 。 而且现在!Buffer Cache Hit Ratio : 70.057 比较低, 发生这种情况以前Buffer Cache Hit Ratio 比较高(89.02左右)。
=======================================================
~Time to Connect : 0 seconds.
~Database Version : Oracle8i Enterprise Edition Release 8.1.6.1.0
~Database Up Since : 11:43:25 上午, 11月 22 2003
!Buffer Cache Hit Ratio : 70.057
~Library Cache Miss Ratio : 0.0145
~Dictionary Cache Miss Ratio : 0.0089
[Shared Pool Usage] Exec Time 0 seconds
~ Total Mb Unused : 127.88
~ Total Mb Used : 772.12
~ Total Mb : 900
~ Shared Pool Percent Used : 85.79
=========================================================
$top
=========================================================
9:54am up 33 days, 22:19, 2 users, load average: 3.78, 4.96, 5.14
191 processes: 185 sleeping, 3 running, 1 zombie, 2 stopped
CPU0 states: 13.3% user, 0.1% system, 0.0% nice, 86.0% idle
CPU1 states: 4.4% user, 0.0% system, 0.0% nice, 95.0% idle
CPU2 states: 17.3% user, 0.3% system, 0.0% nice, 81.3% idle
CPU3 states: 5.0% user, 0.2% system, 0.0% nice, 94.2% idle
CPU4 states: 7.0% user, 0.0% system, 0.0% nice, 92.4% idle
CPU5 states: 10.2% user, 2.2% system, 0.0% nice, 86.4% idle
CPU6 states: 6.3% user, 0.3% system, 0.0% nice, 92.3% idle
CPU7 states: 0.0% user, 100.0% system, 0.0% nice, 0.0% idle
Mem: 3605516K av, 3598616K used, 6900K free, 1734992K shrd, 61056K buff
Swap: 2096440K av, 523928K used, 1572512K free 1098012K cached
PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
18 root 25 0 0 0 0 RW 99.9 0.0 4968m kswapd
18150 oracle 16 0 1028M 1.0G 1025M S 14.3 29.1 112:11 oracle
5925 oracle 17 0 723M 717M 717M R 8.9 20.3 31:02 oracle
11787 oracle 16 0 1322M 1.3G 1316M S 5.3 37.4 267:20 oracle
10760 oracle 15 0 1231M 1.2G 1219M S 4.7 34.6 64:10 oracle
1294 oracle 15 0 1362M 1.3G 1359M S 3.7 38.6 1359m oracle
19303 oracle 16 0 1332M 1.3G 1325M S 3.7 37.6 61:20 oracle
12526 oracle 15 0 1305M 1.3G 1299M S 3.5 36.9 246:39 oracle
24326 oracle 15 0 1401M 1.4G 1394M S 3.3 39.6 263:17 oracle
12153 oracle 15 0 1358M 1.3G 1350M S 2.9 38.3 264:49 oracle
8149 oracle 15 0 132M 130M 129M S 2.9 3.6 2:19 oracle
29298 oracle 15 0 986M 984M 984M S 2.3 27.9 72:48 oracle
30054 oracle 15 0 1361M 1.3G 1359M S 2.1 38.6 886:58 oracle
18699 oracle 15 0 1341M 1.3G 1334M S 1.9 37.9 99:43 oracle
29995 oracle 15 0 1292M 1.3G 1290M S 1.7 36.6 878:44 oracle
24342 oracle 15 0 1370M 1.3G 1364M S 1.7 38.7 281:59 oracle