August 2011
Intermediate to advanced
576 pages
16h 12m
English
book
Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition, 2nd Edition
by K Gopalakrishnan
Content preview from Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition, 2nd EditionBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Commit Frequency
Certain wait events have multiple effects in Oracle RAC. For example, a “log file sync” wait event is associated with excessive commits, and application designers/developers usually are advised to reduce the frequency of their commits to reduce the burden on LGWR and reduce the number of LGWR writes to a log file. A close associate of “log file sync” is “log file parallel write.”
In Oracle RAC environments, log file sync has more implications because each commit or rollback needs SCN propagation and global synchronization, and may also require controlfile synchronization. Hence, extra caution must be exercised in Oracle RAC environments when you are choosing a commit interval or frequency. Some business applications may need ...