Monitoring and Detecting Lock Contention

Objectives

Locking Mechanism

Two Types of Locks

DML Locks

Table Lock Modes

Table Lock Modes

Table Lock Modes

DML Locks in Block

DDL Locks

Possible Causes of Lock Contention

Diagnostic Tools for Monitoring Locking Activity

TopSessions (Diagnostic Pack)

Guidelines: Resolve Contention

Deadlocks

Deadlocks

Summary