log file switch (checkpoint incomplete)
The log file switch (checkpoint incomplete) 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 (checkpoint incomplete) wait event.
Excessive log switches caused by small log files and a high transaction rate
Common Causes, Diagnosis, and Actions
The log file switch (checkpoint incomplete) and the log file switch completion are closely related and share the same root cause—that is, the log files are too small for the amount of redo entries that are generated. When ...
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.
