Discussions about Oracle performance tuning, RAC, Oracle internal & E-business suite. In this blog entry, we will discuss strategies and techniques to resolve ‘log file sync’ waits. This entry is intended to show an approach based upon scientific principes, not necessarily a step by step guide. Let’s understand how LGWR is inherent in implementing commit mechanism first. Commit mechanism and LGWR