Oracle Optimizer Development Team Starts A Blog
December 5, 2007Since the introduction of the Cost Based Optimizer (CBO) in Oracle 7.0, people have been both fascinated and terrified by it and the statistics that feed it. There has long been a belief that a degree in witchcraft or black magic is required to successfully work with the CBO. Some people feel this shroud of mystery is caused in part by the lack of documentation or detailed examples about the Optimizer. In order to help remove this shroud and the black magic that surround the Optimizer, the development team responsible for it have started a blog. The blog postings will give in-depth descriptions of the technology behind the CBO, as well as practical advice like best practices for using the Optimizer. Their first blog post, Why are there more cursors in 11g for my query containing bind variables? went up on December 3rd and it discusses the controversial topic of Bind Peeking and how it has been enhanced in 11g. I recommend you check out their blog at http://optimizermagic.blogspot.com.
8 Responses to “Oracle Optimizer Development Team Starts A Blog”
Thanks for pointing out this Greg, their blog looks promising.
By Yas on Dec 6, 2007
Yet another must-read blog. I guess a few will (have to) get bumped down because this one will be right at the top.
By Wolfgang Breitling on Dec 6, 2007
Damn interesting! Thanks!
By Alberto Dell'Era on Dec 7, 2007
Excellent post. Thanks for sharing Greg.
By Stalin on Dec 7, 2007
Thank you Greg for sharing. I came across your blog from Kevin’s blog.
By satish on Dec 8, 2007
A nice blog. I will add it to my favorites.
By Asif Momen on Dec 9, 2007
Good news! hoping to see more details of optimizer
By victor666666 on Dec 11, 2007
Excellent post Greg. Thanks for sharing to us.
By John on Mar 22, 2008