Advertisement

Minimizing System Contention

  • Sam R. Alapati
  • Darl Kuhn
  • Bill Padfield
Chapter

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

Data Block Free List Parent Table Child Table Database Time 
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

© Sam R. Alapati 2013

Authors and Affiliations

  • Sam R. Alapati
    • 1
  • Darl Kuhn
    • 1
  • Bill Padfield
    • 1
  1. 1.TXUS

Personalised recommendations