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


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

OakTableLogo-small OCMOCMracattack-icon


Jeremy Schneider

Get every new post delivered to your Inbox.

Join 933 other followers