AWR TOP 5 Timed Events Analysis: Top 5 Timed Events - log file switch (checkpoint incomplete)
Fix frequent log switches
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 ...