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.
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