Home > Workload Solutions > Oracle > White Papers > Modernize Your Oracle Database Server Platform and Accelerate Deployments > Oracle online redo logs
While testing OLTP workload using the HammerDB test tool, the Oracle online redo logs were configured to prevent frequent log switching. If database switches online redo log too often, it will affect database performance. We look at the AWR reports to determine the right size of the redo logs and adjust accordingly. In a production deployment, the number of redo logs and sizes also depend on the Recovery Time Objective (RTO) and Recovery Point Objective (RPO). Sizing incorrectly could affect database performance and business RTO and RPO requirements. The following table shows the online redo log layout during our tests.