今天看了一下alert_#sid.log。发现日志更新太频繁。部分内容如下: Mon Nov 30 13:41:21 2009
Thread 1 cannot allocate new log, sequence 360229
Checkpoint not complete
Current log# 2 seq# 360228 mem# 0: E:\ORACLE\ORADATA\CTCMC\REDO02.LOG
Thread 1 advanced to log sequence 360229
Current log# 3 seq# 360229 mem# 0: E:\ORACLE\ORADATA\CTCMC\REDO03.LOG
Mon Nov 30 14:15:56 2009
Thread 1 advanced to log sequence 360230
Current log# 1 seq# 360230 mem# 0: E:\ORACLE\ORADATA\CTCMC\REDO01.LOG
Mon Nov 30 14:16:35 2009
Thread 1 advanced to log sequence 360231
Current log# 2 seq# 360231 mem# 0: E:\ORACLE\ORADATA\CTCMC\REDO02.LOG
Mon Nov 30 14:35:49 2009
Thread 1 advanced to log sequence 360232
Current log# 3 seq# 360232 mem# 0: E:\ORACLE\ORADATA\CTCMC\REDO03.LOG
Mon Nov 30 14:40:00 2009
Thread 1 advanced to log sequence 360233
Current log# 1 seq# 360233 mem# 0: E:\ORACLE\ORADATA\CTCMC\REDO01.LOG
Mon Nov 30 14:40:34 2009
Thread 1 cannot allocate new log, sequence 360234
Checkpoint not complete
Current log# 1 seq# 360233 mem# 0: E:\ORACLE\ORADATA\CTCMC\REDO01.LOG
Thread 1 advanced to log sequence 360234
Current log# 2 seq# 360234 mem# 0: E:\ORACLE\ORADATA\CTCMC\REDO02.LOG日志的切换频率是不是太高了。目前每个日志只有50M大小,要设置成多大的REDO比较好呢?
Thread 1 cannot allocate new log, sequence 360229
Checkpoint not complete
Current log# 2 seq# 360228 mem# 0: E:\ORACLE\ORADATA\CTCMC\REDO02.LOG
Thread 1 advanced to log sequence 360229
Current log# 3 seq# 360229 mem# 0: E:\ORACLE\ORADATA\CTCMC\REDO03.LOG
Mon Nov 30 14:15:56 2009
Thread 1 advanced to log sequence 360230
Current log# 1 seq# 360230 mem# 0: E:\ORACLE\ORADATA\CTCMC\REDO01.LOG
Mon Nov 30 14:16:35 2009
Thread 1 advanced to log sequence 360231
Current log# 2 seq# 360231 mem# 0: E:\ORACLE\ORADATA\CTCMC\REDO02.LOG
Mon Nov 30 14:35:49 2009
Thread 1 advanced to log sequence 360232
Current log# 3 seq# 360232 mem# 0: E:\ORACLE\ORADATA\CTCMC\REDO03.LOG
Mon Nov 30 14:40:00 2009
Thread 1 advanced to log sequence 360233
Current log# 1 seq# 360233 mem# 0: E:\ORACLE\ORADATA\CTCMC\REDO01.LOG
Mon Nov 30 14:40:34 2009
Thread 1 cannot allocate new log, sequence 360234
Checkpoint not complete
Current log# 1 seq# 360233 mem# 0: E:\ORACLE\ORADATA\CTCMC\REDO01.LOG
Thread 1 advanced to log sequence 360234
Current log# 2 seq# 360234 mem# 0: E:\ORACLE\ORADATA\CTCMC\REDO02.LOG日志的切换频率是不是太高了。目前每个日志只有50M大小,要设置成多大的REDO比较好呢?
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
说明DBWR写数据文件的速度已经跟不上日志产生的速度了1
可以增大现有日志文件的大小
2
增加日志组
3
加几个DBWR进程当然 还是前两种方法比较容易实现
刚才研究了下 这个问题。 发了篇blog:Redo Log 和Checkpoint not complete
http://blog.csdn.net/tianlesoftware/archive/2009/11/30/4908066.aspx------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q 群:62697716
我查了一下《Oracle DBA必备技能详解》(Robert G.Freeman)。上面建议最好是15分钟切换一次。呵呵,看来得加大日志文件了。