I'll be presenting at two upcoming webinars:
1. "Oracle Cost-Based Optimizer Basics" hosted by AllThingsOracle.com on Wednesday, 11th April 2012 16:00 (UK Time).
In this session I'll explain the key concepts that influence the decisions of the Oracle Cost-Based Optimizer most. If you want to understand the key concepts about how to write efficient queries and why the optimizer sometimes might not come up with a reasonable execution plan, then this session is for you.
Note that the webinar is free and registrants will receive a recording afterwards. Here is the link to the official AllThingsOracle.com landing page. Thanks to AllThingsOracle.com for hosting this session.
Here is an abstract of the session:
You can read there about the (not so much known) DYNAMIC_SAMPLING_EST_CDN hint, the new Dynamic Sampling auto adjustment feature introduced in release 11.2 and other interesting details.
This time I highlight how to configure Dynamic Sampling - the first part focusing on the available session/statement levels. The next part will be posted soon and explains some other important concepts regarding Dynamic Sampling behaviour.
Unfortunately these topics are not covered very well by the official documentation. In fact the best coverage used to be in the documentation of the initial release that included Dynamic Sampling (9iR2). You can find the link to that old documentation version in the article over there.