Oracle DBA

Transactions, Concurrency & Locking

Question

Read consistency versus locking: how do ordinary queries and DML differ?

Answer

Ordinary queries reconstruct committed data from undo and generally do not lock rows. DML locks changed rows until transaction end. Use consistent reads for reporting; use explicit row locks when a later update needs protection.

This is 12 of 23 free samples for Oracle DBA.

More Oracle DBA topic samples