Abstract
It’s not uncommon for Oracle DBAs to field calls about a user being locked or “blocked” in the database. Oracle’s locking behavior is extremely sophisticated and supports simultaneous use of the database by multiple users. However, on occasion, it’s possible for a user to block another user’s work, mostly because of flaws in application design. This chapter explains how Oracle handles locks and how to identify a session that’s blocking others.
Keywords
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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2013 Sam R. Alapati
About this chapter
Cite this chapter
Alapati, S.R., Kuhn, D., Padfield, B. (2013). Minimizing System Contention. In: Oracle Database 12c Performance Tuning Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-6188-9_5
Download citation
DOI: https://doi.org/10.1007/978-1-4302-6188-9_5
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-6187-2
Online ISBN: 978-1-4302-6188-9
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books