One of the key challenges in developing multiuser, database-driven applications is to maximize concurrent access and, at the same time, ensure that each user is able to read and modify the data in a consistent fashion. The locking mechanisms that allow this to happen are key features of any database, and Oracle excels in providing them. However, Oracle’s implementation of these features is specific to Oracle—just as SQL Server’s implementation is to SQL Server—and it is up to you, the application developer, to ensure ...
© Darl Kuhn and Thomas Kyte 2021
D. Kuhn, T. KyteOracle Database Transactions and Locking Revealedhttps://doi.org/10.1007/978-1-4842-6425-6_22. Locking and Blocking
Get Oracle Database Transactions and Locking Revealed: Building High Performance Through Concurrency now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
