Cache Buffer Chain Analysis (ECO ppt, 17-Oct-2012)
This is the PDF of the powerpoint Craig Shallahamer presented at the ECO Conference on 17-Oct-2012.
Title: Cache Buffer Chain Analysis
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.
Share your knowledge of this product with other customers...
Be the first to write a review
Browse for more products in the same category as this item:
view my cart
To receive OraPub's Newsletter »