log file sync
The log file sync wait event has one parameter: buffer#. In Oracle Database 10g, this wait event falls under the Commit wait class. Keep the following key thoughts in mind when dealing with the log file sync wait event.
The log file sync wait event is related to transaction terminations (commits or rollbacks).
When a process spends a lot of time on the log file sync event, it is usually indicative of too many commits or short transactions.
Common Causes, Diagnosis, and Actions
Oracle records both the transactions and the block changes ...
Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
