Archive for

Adaptive Log File Sync: Oracle, Please Don’t Do That Again

The Summary Underscore parameter _use_adaptive_log_file_sync Default value changed in 11.2.0.3 from FALSE to TRUE Dynamic parameter Enables a new method of communication for LGWR to notify foreground processes of commit Old method used semaphores, LGWR had to explicitly “post” every waiting process New method has the FG processes sleep and “poll” to see if commit … Continue reading →