My Favorite Scripts – 2016

I did a talk at the Dallas Oracle Users Group Technical Training Day which was held on Oct 20th. The title was My Favorite Scripts and basically talked through some of the scripts I use most often and logged on to a system and showed how they work. I promised I would upload the presentation and a zip file here. So here you go.


My Favorite Scripts 2016 – Presentation

My Favorite Scripts 2016 – Zip File


I had a great time doing the talk. I hope you found it useful. Please let me know if you have any questions.


RMOUG 2016 – Controlling Execution Plans Workshop

Thanks to everyone that attended my session. Here’s a quick link to a zip file with the scripts I used in my Controlling Execution Plans Workshop presentation.

Controlling Execution Plans Workshop Zip File

NOUG Fall Training Day

Just a quick note to say that I’ll be speaking in Boston next week. Hope you can make it.

NOUG Fall Training Day

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

” ”


OTN LA Tour 2015 Presentations

Here are links to the presentations for the OTN Latin America Tour 2015.

Controlling Execution Plans (without touching the code)

In-Memory In Action (slides by Tanel Poder) :)