ITPUB
Feb 10, 2017 · Databases
Why an Uncommitted INSERT Can Turn a Simple Oracle SELECT Into a Minutes‑Long Query
A developer encountered a painfully slow SELECT on an Oracle test server, discovered that an uncommitted INSERT left 852 data blocks allocated, causing massive redo size and logical reads, and learned how committing the transaction instantly restores normal query performance.
Consistency ReadOracleSQL
0 likes · 10 min read