上次做系统性能测试,发现原来可以达到的性能指标,这次居然差了很多,还原前台应用与前台服务器再测试,还是跟原来的差很远。
观察发现,应用服务器的压力不大,各种性能指标也都正常,内存用得也不多,CPU更是很闲;数据库服务器的内存没变化,因为总的分配给数据库的内存已经固定了。数据库服务器的CPU使用率也低于10%,io 什么的也很低。
看了好几个awr,也没看出问题来,后来无意间看见alert日志中,很多如下信息
Wed Aug 31 09:54:47 CST 2011
Thread 1 advanced to log sequence 3517 (LGWR switch)
Current log# 1 seq# 3517 mem# 0: +DATA1/orcl/redo01.log
Thread 1 cannot allocate new log, sequence 3518
Checkpoint not complete
Current log# 1 seq# 3517 mem# 0: +DATA1/orcl/redo01.log
Wed Aug 31 09:54:53 CST 2011
Thread 1 advanced to log sequence 3518 (LGWR switch)
Current log# 2 seq# 3518 mem# 0: +DATA1/orcl/redo02.log
Thread 1 cannot allocate new log, sequence 3519
Checkpoint not complete
Current log# 2 seq# 3518 mem# 0: +DATA1/orcl/redo02.log
Wed Aug 31 09:54:59 CST 2011
Thread 1 advanced to log sequence 3519 (LGWR switch)
Current log# 1 seq# 3519 mem# 0: +DATA1/orcl/redo01.log
Thread 1 cannot allocate new log, sequence 3520
Checkpoint not complete
Current log# 1 seq# 3519 mem# 0: +DATA1/orcl/redo01.log
Wed Aug 31 09:55:05 CST 2011
Thread 1 advanced to log sequence 3520 (LGWR switch)
Current log# 2 seq# 3520 mem# 0: +DATA1/orcl/redo02.log
Thread 1 advanced to log sequence 3517 (LGWR switch)
Current log# 1 seq# 3517 mem# 0: +DATA1/orcl/redo01.log
Thread 1 cannot allocate new log, sequence 3518
Checkpoint not complete
Current log# 1 seq# 3517 mem# 0: +DATA1/orcl/redo01.log
Wed Aug 31 09:54:53 CST 2011
Thread 1 advanced to log sequence 3518 (LGWR switch)
Current log# 2 seq# 3518 mem# 0: +DATA1/orcl/redo02.log
Thread 1 cannot allocate new log, sequence 3519
Checkpoint not complete
Current log# 2 seq# 3518 mem# 0: +DATA1/orcl/redo02.log
Wed Aug 31 09:54:59 CST 2011
Thread 1 advanced to log sequence 3519 (LGWR switch)
Current log# 1 seq# 3519 mem# 0: +DATA1/orcl/redo01.log
Thread 1 cannot allocate new log, sequence 3520
Checkpoint not complete
Current log# 1 seq# 3519 mem# 0: +DATA1/orcl/redo01.log
Wed Aug 31 09:55:05 CST 2011
Thread 1 advanced to log sequence 3520 (LGWR switch)
Current log# 2 seq# 3520 mem# 0: +DATA1/orcl/redo02.log
网上找了一下,说是因为 log 日志组太少或者日志文件太小了,查了一下,确实,2组一共加起来才200M,马上加到800M,问题得以解决。
用的非归档模式,本以为这个redo日志大小不会是问题,没想得栽在这上面,折腾好久才解决。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9399028/viewspace-707735/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9399028/viewspace-707735/