Locking and Issues

  • Thomas Kyte
  • Darl Kuhn
Chapter

Abstract

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 that when your application performs data manipulation, it uses these mechanisms correctly. If you fail to do so, your application will behave in an unexpected way, and inevitably the integrity of your data will be compromised.

Keywords

Hash Table Concurrent Access Hash Algorithm Parent Table Version Column 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Thomas Kyte 2014

Authors and Affiliations

  • Thomas Kyte
    • 1
  • Darl Kuhn
    • 1
  1. 1.VAUnited States

Personalised recommendations