Enhanced Data Locking to Serve ACID Transaction Properties in the Oracle Database

Abstract

Relational databases are characterized by precise data model, formed by the entities and relationships. Integrity and consistency is maintained by the transactions, which ensure transfer from one consistent state to another. Consistency is ensured at the latest at the end of the transaction itself. SQL norm specifies two lock types applied on the data row level to serve the consistency in the parallel data access. However, Oracle Database uses a different approach relying on the transaction logs to provide historical consistent data image. In this paper, Reservable attributes are discussed, introduced in Oracle 23c version by focusing on the performance, limitation and general issues.

Keywords

• database performance
• oracle database
• reservable column
• data lock
• transaction