Common Oracle DB pitfall: too less redo log groups | Peter Ramm
Oracle: Redo Log Waits - Embarcadero DB Optimizer
AWR TOP 5 Timed Events Analysis: Top 5 Timed Events - log file switch (checkpoint incomplete)
increase redo log size let's see what happens So now we have increased the log buffer to 160k from the default 8k We see that the main waits are on log_file_switch_completion log_file_switch_(checkpoint_incomplete) So we must be switching log files alot ...