My Oracle Support Banner

How to Estimate Size of Redo Logs (Doc ID 1038851.6)

Last updated on MAY 18, 2024

Applies to:

Oracle Database - Enterprise Edition - Version and later
All Platforms


How to Estimate the Size of Redo Logs in Oracle 7 and 8i and above:

The best way to determine the optimal size of redo log files is to look into the alert.log file for messages about how frequently the log
sequence# are changing, log check pointing and any incomplete redo log switch completion messages.
When you examine your alert.log for log switches, you should do it when there are heavier loads in the database.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.