Mar
19
2010
1
Row-level and table-level locking in Oracle and MySQL
By David Luhman
I had a recent discussion with someone who believed that Oracle's default locking behavior on inserts was table-level locking.
From a practical perspective, the notion that an OLTP database like Oracle would use table-level locks for inserts would lead to such inconceivably bad performance for enterprise applications that I had to research this a bit. From what I can see, default Oracle behavior is ROW-LEVEL locking for inserts.