O'Reilly logo

Oracle by Guy Harrison

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required