Intro to Oracle Buffer Cache Internals (OTN LAC Tour August 2012 ppt)
This presentation was given by Craig Shallahamer at the OTN Latin American Tour in August of 2012 in Buenos Aires, Argentina. This is one of Craig's most popular presentations, so you may notice it is posted for a number of difference conferences. Usually you want to download the recent version.
To download the zip file, add this
to your chart and checkout.
While Oracle's buffer cache consists entirely of database blocks, the buffer headers and the supporting lists/chains are what makes the buffer cache a consistent topic of importance, interest, and challenge. Using creative visualizations, the presentation begins by introducing the key buffer cache structures followed by Craig role playing as a server process performing a variety of server process related activities. This naturally leads into when and how CPU is consumed and how the various buffer cache related wait events manifest, such as free buffer waits, read by other session, and cache buffer chain and LRU latch contention. Both new and experienced Oracle DBAs will find this presentation informative, practical, and entertaining.
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 activity updates »