Menu

#Redo

5 posts

Feed·
4 of 5 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·1 day 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