Oracle Scratchpad

CBO Series

I’m writing a series of articles about the cost-based optimizer for AllthingsOracle. My intention in this series is to present the optimizer with far less formality than I did in the book (Cost Based Oracle – Fundamentals), talking through ideas, problems and solutions and only presenting some arithmetic to explain why a problem appears or why a solution works.

So far I’ve published six installments:

RFC:  the CBO is enormous. If there are areas that you would like me to write about in this series give me some idea in the comments below of what you’d like explained and I’ll try to write about it at some point in the series. Try to stick with concepts and principles, don’t give me a long description of a specific problem unless you think I can extract a general principle from it, and if you want to include execution plans etc. use the “sourcecode” “/sourcecode” tags (replace the quotes with square brackets) to get a fixed font output.

Update (March 2016)

The entire series to date (6 installments) has been translated into Chinese by James Su at this URL.

 

7 Comments »

  1. […] I’ve changed the catalogue from a post to a page so that it gets a static address: https://jonathanlewis.wordpress.com/cbo-series/ […]

    Pingback by CBO series | Oracle Scratchpad — July 19, 2015 @ 10:17 am BST Jul 19,2015 | Reply

  2. […] –> Catalogue of current articles in order. […]

    Pingback by Basics of the Cost Based Optimizer – Part 1 – All Things Oracle — July 19, 2015 @ 10:50 am BST Jul 19,2015 | Reply

  3. […] –> Catalogue of current articles in order. […]

    Pingback by Basics of the Cost Based Optimizer – Part 2 – All Things Oracle — July 19, 2015 @ 10:50 am BST Jul 19,2015 | Reply

  4. […] –> Catalogue of current articles in order. […]

    Pingback by Basics of the Cost Based Optimizer – Part 3 – All Things Oracle — July 19, 2015 @ 10:51 am BST Jul 19,2015 | Reply

  5. […] –> Catalogue of current articles in CBO series. […]

    Pingback by Basics of the Cost Based Optimizer – Part 4 – All Things Oracle — August 31, 2015 @ 11:55 am BST Aug 31,2015 | Reply

  6. […] –> Catalogue of current articles in CBO series. […]

    Pingback by Basics of the Cost Based Optimizer – Part 5 – All Things Oracle — November 4, 2015 @ 8:10 am BST Nov 4,2015 | Reply

  7. […] –> Catalogue of current articles in CBO series. […]

    Pingback by Basics of the Cost Based Optimizer – part 6 – All Things Oracle — November 4, 2015 @ 10:01 am BST Nov 4,2015 | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.