log file switch completion
The log file switch completion wait event has no wait parameters. In Oracle Database 10g, this wait event falls under the Configuration wait class. Keep the following key thought in mind when dealing with the log file switch completion wait event.
Excessive log switches caused by small log files and transactions that generate a lot of redo entries
Common Causes, Diagnosis, and Actions
If a session spends much of its processing time waiting on the log file switch completion event, this is because the redo log files are too small for the amount of redo entries that are being generated, causing too many log switches. The ...
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.
