Excessive Redo Generation
Hi,
I have a database with excessive redo generation (2 to 5 time/min (average)). I have 5 redo log groups, each group has 2 members and each redo file size is 50MB. I am going to increase to 200MB to accommodate the high volume data changes. I noticed each archived redolog file is only between 3-10MB in size (mostly are 3 MB in size) Each redolog file is allocated 50MB. I am wondering why Oracle switch the log file when it is still have space to write to. Anyone know why this happened??? I didn't set log_checkpoint_interval, the value is zero.
I have a database with excessive redo generation (2 to 5 time/min (average)). I have 5 redo log groups, each group has 2 members and each redo file size is 50MB. I am going to increase to 200MB to accommodate the high volume data changes. I noticed each archived redolog file is only between 3-10MB in size (mostly are 3 MB in size) Each redolog file is allocated 50MB. I am wondering why Oracle switch the log file when it is still have space to write to. Anyone know why this happened??? I didn't set log_checkpoint_interval, the value is zero.
0