1. Get Started with Performance Tuning
  2. Reactive Database Tuning
  3. Using Automatic Workload Repository Warehouse for Generating Performance Reports
  4. AWR Warehouse Best Practices
  5. Database Best Practices
  6. Redo Log Size

Redo Log Size

It is important to size the redo logs correctly. A small redo results in frequent log switches affecting database performance. The amount of redo generated in AWR Warehouse varies based on the number of source databases moving their AWR data into the warehouse. Oracle recommends a minimum of 1GB redo log sizing.