-
Blocked Inserts- Locking and Latching
There are a few times when an INSERT will block. The most common scenario is when you have a table with a primary key or…
-
TX (Transaction) Locks- Locking and Latching-1
A TX lock is acquired when a transaction initiates its first change. The transaction is automatically initiated at this point (you don’t explicitly start a…
-
Optimistic Locking Using a Checksum – Locking and Latching
This is very similar to the previous version column method, but it uses the base data itself to compute a “virtual” version column. I’ll quote…
-
Locking Issues – Locking and Latching
Before we discuss the various types of locks that Oracle uses, it is useful to look at some locking issues, many of which arise from…