Advertisement

Minimizing System Contention

  • Sam R. Alapati
  • Darl Kuhn
  • Bill Padfield

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 due to flaws in application design. This chapter explains how Oracle handles locks and how to identify a session that’s blocking others.

Keywords

Data Block Bind Variable Free List Blocking Session Child Table 
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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Sam R. Alapati, Darl Kuhn, and Bill Padfield 2011

Authors and Affiliations

  • Sam R. Alapati
  • Darl Kuhn
  • Bill Padfield

There are no affiliations available

Personalised recommendations