Controlling Execution Plans Workshop

I did a workshop at ECO 2015 today. It was a lot of fun. I’ve done numerous presentations on SQL Profiles, SQL Patches and Baselines in the past, but this session was a no-slides, hands on demo of some of the scripts I use. I also showed some scripts that can be used to re-write SQL on the fly using a new feature of 12c called SQL Translation Framework. Here is a zip file that contains all the scripts and the Controlling Executions Plans presentation that I mentioned during the workshop.

Controlling Execution Plans Workshop Zip File

” ”



  1. Muthu Krishnan says:


    Nice one, thanks.

  2. Good blog. Thanks a lot for using the great services in this blog and thanks a lot for providing the nice approach.

  3. soujanya says:

    Thanks for sharing info on Controlling Execution Plans Workshop

  4. jr-phdba says:

    Thanks for sharing.

Leave a Reply