Session ID: 1680


Oracle memory serialization control is core to Oracle database operations. One of the most fascinating topics in Oracle internals and performance optimization is memory serialization. We will look at when serialization is used, how it works, how we can influence its operation, and how we can diagnose problems. But, it's a complex situation. To get the upper hand on serialization control this presentation will explore the lock (a little), the latch (a lot), and the mutex (a whole lot). Topics include performance diagnosis, how Oracle implements latches and mutexes, and the related internal algorithms. Special attention is given to the library cache mutex operations. This is a very practical yet deep internals presentation, filled with amazing discoveries about how Oracle works.

Objective 1: Learn how to confidently diagnose memory serialization problems

Objective 2: Learn how Oracle implements and uses latches and mutexes

Objective 3: Learn how we can influence the latch and mutex algorithms

Audience: Mid-Level