Chapter 15. Lock Contention

This chapter is the first of several that deal with the various types of contention that commonly inflict Oracle databases.

As we discussed in Chapter 1, “Oracle Performance Tuning: A Methodical Approach,” contention occurs when two or more sessions attempt to simultaneously utilize limited or serialized resources. Contention limits the amount of work that the database can get done because sessions queue up for the limited resources concerned.

We introduced the concepts of transactions and locking in Chapter 4, “Logical and Physical Database Design.” The ACID (Atomic-Consistent-Independent-Durable) properties of transactions, especially the consistency characteristic, require that Oracle limit concurrent changes to ...

Get Oracle now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.