Increase Transaction Log Buffer Size When Using XLA

Performance impact: Large

A larger transaction log buffer size is appropriate when using XLA.

When XLA is enabled, additional transaction log records are generated to store additional information for XLA. To ensure the transaction log buffer is properly sized, one can watch for changes in the SYS.MONITOR table entries LOG_FS_READS and LOG_BUFFER_WAITS. For optimal performance, both of these values should remain 0. Increasing the transaction log buffer size may be necessary to ensure the values remain 0. See LogBufMB in the Oracle TimesTen In-Memory Database Reference.