log buffer question

Hello.
I'm running 8.1.7 on Solaris 2.7. My database supports a web site.

When oracle writes to the redo log file, such as when a user performs a commit,
does it write LOG_BUFFER (setting in the init.ora) number of bytes? ie. flush the entire log buffer?

Or does it only write transaction's redo buffer information?

The reason I'm asking is that the top two wait events in our system is log file sync and log file parallel writes. Since these two events have waits
on the same order of magnitude I'm assuming that we're writing to the redo log at a high rate b/c of the number of commits in our system. And we have LOG_BUFFER set to 512K and our redos at 10M we are seeing 100's of log switches in an hour. And I'm hoping that if we reduce LOG_BUFFER the log switch frequency will go down.

Thanks. Received on Thu Aug 16 2001 - 03:06:40 CDT