Common Oracle DB pitfall: too less redo log groups | Peter Ramm
Oracle local write wait and enq:RO - fast object reuse wait event Description - Programmer Sought
Kyle Hailey » Redo log waits in Oracle
Oracle Wait Events That Everyone Should Know Kerry
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 ...
Common Oracle DB pitfall: too less redo log groups | Peter Ramm