Evolving Transactions in Oracle 23ai: New Advances in Concurrency and Consistency

Oracle Database 23ai introduces groundbreaking enhancements that redefine transaction processing, ensuring greater concurrency, flexibility, and efficiency. This talk will explore four key features that impact database transactions: Logical Replication of JSON Relational Duality Views, Lock-Free Reservations, Sessionless Transactions, and Value-based Concurrency Control. Learn how we logically and consistently replicate data stored in JSON Relational Duality Views to heterogenous target data stores. The Lock-free Reservations feature boosts concurrency of hot data, enhancing system efficiency. Sessionless Transactions enables lightweight and efficient transactions in the database, reducing complexity in building modern applications. Value-based Concurrency Control introduces a novel concurrency control approach that increases parallelism by reducing the locking duration.