OUGN 2014 & the “Mastering Oracle Trace Data” class with Cary Millsap

My first OUGN seminar on Color Magic is over. Here is a summary of what it included.
I’m truely coming back next year!

The 2nd of April: Mastering Oracle Trace Data, Cary Millsap

One day with Cary Millsap. How cool is that? I know this is the kind of words my 11 year old daughter probably would use if she could spend a day with Justin Bieber. But this day I had been looking forward to for so long. The “Master Oracle Trace Data” class with Cary in Oslo.

I’ve fallen in love with the tools from Method-R a long time ago. But after a day with Cary I realized I’ve only used less than 1 % of it. The ways you can use these tools are endless. I’ve been to several presentations with Cary before, but I always learn something new. This day was no different. And the best part – it was not over with this. The next days Cary should join us on “the boat” for the OUGN spring seminar of 2014. Well … Cary pointed out that a boat with boats on it is really a ship :-). Thanks for a great course Cary!

The 3rd of April: OUGN Day 1

This is my first time on “the boat”. I was supposed to join last year, but had to work instead. Because of this my presentation (about Oracle End-to-end metrics) was moved to the first day on shore. I have really heard a lot of great things about the OUGN spring seminar and “the boat”. Now – I finally was here.
Continue Reading »

Removing unwanted “unaccounted-for …” waits from trace

methodr_logoAfter removing think time (or idle SQL*Net message from client) from a trace file (see a description), an unwanted line of “unaccounted for between dbcalls” dominated my MethodR profiler report. After an e-mail to MethodR support, Cary Millsap & Jeff Holt, found a way to neutralize this unwanted line. In this post I’ll show how. Thanks to Cary Millsap & Jeff Holt!

Continue Reading »

Removing idle “SQL*Net message from client” waits from trace

MethodROne important task when working with Oracle trace is to distinguish between idle and significant “SQL*Net message from client” waits. Default, MethodR defines waits above 1 second as “think time”. These waits are usually identified as idle waits. For instance – in an application using a connection pool, the sessions will be waiting for a client thread to grab a connection. These waits are truly not tied to the application response times, but is idle waits. In this article I’ll show how these waits easily can be “removed” or neutralized by using the MethodR utilities.

Continue Reading »

Oslo April 2nd: “Mastering Oracle Trace Data” with Cary Millsap

carymillsapJoin the seminar.

Cary Millsap is comming to town. The second of April Cary is giving his course “Mastering Oracle Trace Data” in Oslo. And most important of all: I’ll be there!

I’m really looking forward to meet mr. Cary Millsap in the class room. I’ve enjoyed many of his presentations earlier, and have become one of his shepherds regarding Oracle end-to-end metrics. Oracle trace is one of my favorite tools when it comes to Oracle tuning and performance trouble shooting. I do have a license of the method-r software, and are looking forward to a deap dive into the utilities.

Speaking at #OUGN2014: “Source Control – not only for developers”

OUGN14_Speaking_200pxHope to see you at my presentation in April. Want to attend? http://www.ougn.no/ougn-vrseminar-2014

My presentation “Source Control – not only for developers” just got admitted to the 2014 conference program in April. This time I’ll actually give a quite new presentation. Usually I talk about performance, and recently I’ve given quite a few presentations about Oracle End-to-End Metrics. I do enjoy talking about performance issues, but now I’m looking forward to talk about Source Control for database changes.

Continue Reading »

Masking with redaction in Oracle 12c

The new redaction features in Oracle 12c looks very promising. Th article “Hide from Prying Eyes” by Arup Nanda gives a quick introduction to the new feature.

PLSQL: 11g datatypes for performance

I just got a tip regarding an article about new datatypes possibly increasing PL/SQL performance in 11g (Thank you Patrick). Here is the article:


JavaZone 2013: “Oracle SQL Hacking Session: Just you, me, Java and a Oracle database”


(To see the presentation: Open article and press this link)

Today I got an e-mail telling me that my presentation, “Oracle SQL Hacking Session: Just you, me, Java and a Oracle database”, has been accepted for JavaZone 2013. Hopefully my other paper about End-To-End Metrics also will be accepted.

I’m really excited about this. I’ve been at JavaZone for the last 2-3 years, and have been missing presentation about RDBMS databases. The focus has clearly been on NoSQL databases, and non what so ever about Oracle and/or SQL. I’ve nothing against NoSQL databases. I’m using some myself, but the RDBMS is not dead – yet!