Oracle Database 11gR2 Performance Tuning Cookbook

Chapter 11. Tuning Contention

In this chapter, we will cover:

• Detecting and preventing lock contention
• Investigating transactions and concurrency
• Tuning latches
• Tuning resources to minimize latch contention
• Minimizing latches using bind variables

Introduction

In this chapter we will focus on preventing, detecting, and tuning contention-related issues.

In a database, as in any information system, there is a limited amount of resources to be shared among many users. When more than one user asks for a resource—which can be a file, a row in a table, a block in the buffer cache—there is a need for a synchronization mechanism to avoid the contemporary use of the resource itself by more than one user at a time.

In this chapter we will investigate two different ...