O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required