Menu

#Redo

6 posts

Feed·
5 of 6 posts
Checkpoint Not Complete: Every Commit Waits, and the SQL Is Fine
📰
0Read More

Checkpoint Not Complete: Every Commit Waits, and the SQL Is Fine

DEV Community: database·Uptime Architect·23 days ago
#jrRybKo3
#devtodatabase#devto#dev#redo#logs

Why an Oracle database freezes every writer for seconds at a time while the SQL is fine: online redo logs too small for the write rate, the log writer lapping the checkpoint, and the alert log's 'Checkpoint not complete'.…

15s