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 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


This is my personal website. The views expressed here are mine alone and may not reflect the views of my employer.

contact: 312-725-9249 or schneider @ ardentperf.com




Enter your email address to receive notifications of new posts by email.

Join 56 other subscribers