Loading…
View analytic
Thursday, March 22 • 9:45am - 10:45am
Understanding and Optimizing Oracle Memory Serialization Access (Latches and Mutexes)

Sign up or log in to save this to your schedule and see who's attending!

Feedback form is now closed.
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.

Speakers
CS

Craig Shallahamer

Oracle ACE Director, OraPub
Craig is a long time Oracle DBA who specializes in Oracle tuning and started the OraPub website in 1995. Craig is a performance researcher and blogger, consultant, author of two books, an enthusiastic conference speaker and a passionate teacher to thousands of Oracle professional... Read More →


Thursday March 22, 2018 9:45am - 10:45am
5130, 5th Floor 1655 East Campus Center Drive, Salt Lake City, Utah 84112