Archive for October 2012

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


(a) This is my personal blog.

The views expressed on this website are mine alone and do not necessarily reflect the views of my employer.



Jeremy Schneider

Get every new post delivered to your Inbox.

Join 931 other followers