Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Archive logs cutting early

jasnoOct 29 2009 — edited Jan 22 2011
Hello, 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2011
Added on Oct 29 2009
6 comments
653 views