Redo Log File Sizings
The size of the redo log files influences performance because the database writer and archiver processes depend on the redo log sizes. Larger redo log files tend to provide better performance along with appropriate expected recovery time. If the redo log files are small, they increase checkpoint activity and increase CPU usage. Smaller redo logs lessen the performance, because during log switching, all operations are frozen in the database and all sessions may wait for log switch completion.
Checkpoint frequency is influenced by log-file size and by the FAST_START_MTTR_TARGET parameter, among several factors. If the FAST_START_MTTR_TARGET parameter is set to limit the instance recovery time, Oracle automatically tries to ...
Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
