My Oracle Support Banner

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

Last updated on JANUARY 04, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 7.3.4.5 and later
All Platforms

Purpose

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.

Scope

 

Details

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.