Resolving Buffer Busy Related Contention - OTN Tour

  • Posted on: 10 November 2011
  • By: milina.ristic
Author/Owner: 
Craig Shallahamer
The buffer busy wait and read by other session are two of the most intriguing wait events. While Oracle never officially locks a buffer, during high concurrency situations buffers can become too busy to access. A methodical step-by-step diagnosis and a solid grasp of the relevant Oracle internals is particularly important because there are a number of reasons why a buffer can become too busy and the solutions are derived in part by understanding the underlying Oracle structures. This presentation guides you through the process of discovering if there is a significant problem, the related Oracle internal structures, wait event name changes, a spot-on diagnosis method, and solutions for the most common situations you're likely to face.
Version: 
1
Publish Date: 
10 Nov 2011
Website: 
Resolving Buffer Busy Related Contention
Organization: 
OraPub Inc
Presenter Biography: 
Craig is a researcher, writer, and teacher for 1000s of Oracle professionals. His focus is Oracle performance management, which has led to a string of publishing over 24 technical papers and authoring the books Oracle Performance Firefighting and Forecasting Oracle Performance. Craig is the creator and teacher of the popular Advanced Oracle Performance Analysis, Oracle Performance Firefighting, and the Oracle Forecasting & Predictive Analysis courses. After nine years with Oracle Corporation in which he co-founded the Core Technologies and the System Performance Groups, in 1998 he left Oracle to start OraPub, Inc. He is a passionate educator, a pinnacle of Oracle knowledge, and an engaging instructor. His entertaining presentation style combines with his depth of Oracle experiences to make each presentation unique. An Oracle ACE Director, he has taught 1000s of Oracle professionals on 6 continents in 24 countries.
field_vote: