Row-level and table-level locking in Oracle and MySQL

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.

Subscribe to RSS - Oracle