December 8, 2010
While reading the “Oracle Tuning the Definitive Reference Second Edition” book I found a handful of interesting suggestions regarding Oracle wait events. Take 60 seconds to analyze the following quote from page 656:
“There are three columns of the v$session_wait view that are of particular interest for a buffer busy wait event: … The following is an Oracle data dictionary query for these values:select p1 "File #". p2 "Block #", p3 "Reason Code" from v$session_wait where event = 'buffer busy waits';
Keeping in mind that the book is printed after the release of Oracle Database 188.8.131.52 (and possibly 184.108.40.206 for some operating system platforms), what, if anything, is wrong with the above quote?
While my review of the book only provides an in-depth technical review of the first 200 pages of the book, this blog article series will dig into some of the pages that were not specifically included in the review.
The point of blog articles like this one is not to insult authors who have spent thousands of hours carefully constructing an accurate and helpful book, but instead to suggest that readers investigate when something stated does not exactly match what one believes to be true. It could be that the author “took a long walk down a short pier”, or that the author is revealing accurate information which simply cannot be found through other resources (and may in the process be directly contradicting information sources you have used in the past). If you do not investigate in such cases, you may lose an important opportunity to learn something that could prove to be extremely valuable.
Other pages found during a Google search of the phrase:
- Previous edition of the book