Archive logs cutting early
jasnoOct 29 2009 — edited Jan 22 2011Hello, I have a 11g 11.1.0.7 database running on Windows Server 2003 64bit. This is a new server and database that will be replacing our 10g 32bit system. Everything is running fine on it, the only weird thing I have noticed is that the Redo logs cut early. I have them set to 50mb and they seem to always cut at 25mb. Once in a while I will get one that is around 44mb. I do not have the ARCHIVE_LAG_TARGET parameter set. I am confused as to why I can only get 25mb into an Archive log. I have Automatic Memory Management enabled and the Maximum Memory size is set to 15gb. I also have Large Page support enabled.
On my current 10g server, the archive logs are being cut about every 5 minutes and I am trying to set this new server to cut 1 or 2 an hour. Having these logs cut early is making it difficult to determine what size Redo logs I need. I guess I could set them to a much larger size and then set the ARCHIVE_LAG_TARGET parameter to cut every 60 minutes but I want to make sure something isn't set incorrectly to cause the early cut of the Redo log. My Redo Buffer size is 61665280 bytes when I check "Show SGA". Any help with this would be appreciated.