Lock Types

  • Thomas Kyte
  • Darl Kuhn
Chapter

Abstract

In this chapter, we’ll take a detailed look at how Oracle locks both data (e.g., rows in tables) and shared data structures (such as those found in the SGA). We’ll investigate the granularity to which Oracle locks data and what that means to you, the developer. When appropriate, I’ll contrast Oracle’s locking scheme with other popular implementations, mostly to dispel the myth that row-level locking adds overhead; in reality, it adds overhead only if the implementation adds overhead. In the next chapter, we’ll continue this discussion and investigate Oracle’s multiversioning techniques and how locking strategies interact with them.

Keywords

Bind Variable Shared Pool Concurrent Transaction Lock Manager Serialization Device 
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

© Thomas Kyte 2014

Authors and Affiliations

  • Thomas Kyte
    • 1
  • Darl Kuhn
    • 1
  1. 1.VAUnited States

Personalised recommendations