** log_buffer
From: A Joshi <ajoshi977_at_yahoo.com>
Date: Tue, 22 Jul 2008 09:00:50 -0700 (PDT)
Message-ID: <411747.51665.qm@web58002.mail.re3.yahoo.com>
Date: Tue, 22 Jul 2008 09:00:50 -0700 (PDT)
Message-ID: <411747.51665.qm@web58002.mail.re3.yahoo.com>
Hi,
Is any specific formula to find the optimum log_buffer size. Any considerations. I read that any size above 3MB might not help since it flushes at that point anyway. Database version 9i. We are seeing high log file sync waits and also log buffer space waits. Thanks
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 22 2008 - 11:00:50 CDT