A b s t r a c t 

Presenter: Craig Shallahamer
Organization: OraPub
Biographical Sketch: Craig Shallahamer is a longtime Oracle DBA (1989) who specializes in Oracle Database performance. He is also an Oracle ACE Director, performance researcher and blogger, consultant, author of two books ("Oracle Performance Firefighting" and "Forecasting Oracle Performance"), an enthusiastic conference speaker, and a passionate teacher to thousands of Oracle professionals. He is the founder and president of OraPub and creator of the performance analysis tool Stori, and he clearly pushes the teaching envelope with his online seminars. His blog, A Wider View, is where to find his most recent public performance research. He can be contacted at craig@orapub.com, @CShallahamer, and LinkedIn.
Title: Resolving Cache Buffer Chain Latch Contention
Abstract: The numbers are intimidating: perhaps trillions within a single hour. When a server process needs to access a buffer, it must first access the cache buffer chain (CBC) structure to determine if the buffer is in the buffer cache. While serialization control protects the CBC structure, given high concurrency and just the right workload mix, performance can be a problem. Through amazing visualizations and entertaining role playing, you'll learn the relevant Oracle internals, quantitative methodical problem diagnosis, and solutions related to the three most common CBC struggles: a hot index root block, extremely high buffer cache chain concurrency, and buffer cloning.
Topic: Database Development
Target Audience: All
Location: 307

GaOUG Tech Day
March 3, 2016

Conference Administration Tool | Copyright © 2017, Prairie Systems Group, Limited