Locking behavior

If you update a database table, an RDBMS must use a locking mechanism to ensure data integrity. To lock the physical data, oracle uses row level locking; therefore, the smallest unit of data you can lock is the row.

To ensure data integrity, the LN Oracle database driver uses Oracle’s locking mechanism. The database driver uses several locking strategies, including:

• Implicit and explicit locking.
• Delayed locking.
• Statement and lock timeouts.
• High level lock retries.