Archive for the ‘Oracle’ Category.

DOAG 2016

I had a great time at DOAG 2016. It’s one of the best run conferences I’ve been to! I did a quick cameo during the keynote to talk about performance in Oracle’s cloud. Nothing like being on stage with a guy wearing a tie. :) Thanks Andrew for inviting me to say a few words.

Kerry_on_stage_doag_2016

Oracle Cloud Performance Testing Results


 

That was fun!

Then I did a couple of technical talks.

The first was on SQL Translation Framework. The second was supposed to be a workshop where I just logged on to a system and ran through some of my scripts for controlling execution plans. Unfortunately the computer gods were not with me and I had to fall back to power point instead. So I did an abbreviated version of my Controlling Execution Plans (without touching the code) talk instead.

Anyway, I had a great time. Please let me know if you have any questions.

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

” ”

Morphine