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 (as was demonstrated in Chapter 1 “Developing Successful Oracle Applications”).
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Editor information
Rights and permissions
Copyright information
© 2010 Thomas Kyte
About this chapter
Cite this chapter
(2010). Locking and Latching. In: Gennick, J., et al. Expert Oracle Database Architecture. Apress. https://doi.org/10.1007/978-1-4302-2947-6_6
Download citation
DOI: https://doi.org/10.1007/978-1-4302-2947-6_6
Publisher Name: Apress
Print ISBN: 978-1-4302-2946-9
Online ISBN: 978-1-4302-2947-6
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books