POUG 2018

I just returned from a great Technical Oracle Conference hosted in Poland by my friends Kamil (@ora600pl) and Luiza (@LuizafromPoland)! They were kind enough to allow me to speak on the topics of SQL Translation Framework and Advanced Query Rewrite. It was my second year in a row to attend this conference and I must say I was extremely impressed by the content and the speakers and the venue and the professional handling of the (more...)

Hotsos Symposium 2018

Just a quick note to say I’m doing a couple of talks at this year’s Hotsos Symposium, which starts next Monday at 8:30AM. It’s not too late to register.

As an enticement – here is one of my favorite pictures from last year’s event: (Come join the fun!)

IMG_0379

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

That was fun! Here’s a link to the paper I referenced:

Oracle Cloud Performance Testing Results


 

Then I did (more...)

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 (more...)

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 (more...)

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) :)

ECO 2014 Slides

Just a quick note that I posted slides for the 2 talks I did at ECO in Raleigh this week:

Keynote: Creative Problem Solving (for Oracle Systems)

In-Memory In Action (without Tanel Poder) :)

Great crowd. I really enjoyed myself.

Note: You can also find other presentations on my Whitepapers/Presentations page via the link at the top of the screen.

Interesting Oracle Syntax Error

As shared by a well known Oracle and Big Data performance geek!

SQL> ALTER SYSTEM SET inmemory_size = 5T SCOPE=spfile;
ALTER SYSTEM SET inmemory_size = 5T SCOPE=spfile
*
ERROR at line 1:
ORA-32005: error while parsing size specification [5T]


SQL> ALTER SYSTEM SET inmemory_size = 5120G SCOPE=spfile;

System altered.

:)