14.2Tuning Hardware Resources for Data Warehousing401
Chapter 14
file size. In addition, recall that the redo log buffer is flushed or written to
the current redo log file whenever a COMMIT or ROLLBACK is issued;
the redo log buffer is partially filled to one-third full every three seconds or
if the redo log reaches 1Mb.
Note: A checkpoint is a process of flushing dirty buffers from database
buffer cache to disk storage. The redo log buffer is not flushed to disk when
a checkpoint occurs. This is the consensus of opinion from a number of
DBAs, and contrary to many Oracle software texts.
So how does the size of the log buffer affect the redo log files?
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.