REDO日志大小
今天看了一下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比较好呢?