My Oracle Support Banner

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

Last updated on NOVEMBER 27, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 7.3.4.5 and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A 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.