Author Archives

An Oracle DBA at JavaZone – a fish on land?

Why in the world should an Oracle DBA spend two workdays at a Java conference like JavaZone. It doesn’t matter if the JavaZone is the third biggest Java conference in the world, serve great food all day long, have a concert at night with awesome bands, and – of course – you get a couple […]

Books to read: “Mastering Oracle Trace Data, Second Edition” with Cary Millsap

The “Mastering Oracle Trace Data” from Cary Millsap is a great book about performance in general, and about how to work with trace data. The second edition have several new chapters adding valuable knowledge to both developers and DBAs. This is one of the books that you really should have in your bookshelf.

One of the things you just need to know about Oracle …

A couple of years ago I did ask my developers to start using the varchar2(char) option when creating new tables. In Norway we have some characters in the alphabet (‘Æ’, ‘Ø’, ‘Å’) that uses more than 1 byte of storage (when the database characterset is set to AL32UTF8). Using the default – varchar2(byte) – could then decrease the number […]

Sometimes it’s alright to be LAZY – Part 2

Thanks to my coworkers David Karlsen and Lars Johan Ulveseth for introducing me to the world of Vagrant & SALT, and letting me use some of their work on this. Earlier post: Sometimes it’s alright to be LAZY – Part 1 In part 1 we looked at the tools Oracle VirtualBox and Vagrant, and how […]

Paginating over parent table (in one-to-many join)

Just spent an hour of figuring out how to do pagination on the parent table in a one-to-many join. I did try to google it, but didn’t find any solution on this. Then I started to play around with the analytic functions, and managed to do this:

Sometimes it’s alright to be LAZY – Part 1

Thanks to my coworkers David Karlsen and Lars Johan Ulveseth for introducing me to the world of Vagrant & SALT, and letting me use some of their work on this. The best system administrators and developers I know are down right lazy. In a good way of course. They are experts in finding ways to […]

Speaking at Oracle OpenWorld 2014, San Francisco

The last  years I’ve attended Oracle OpenWorld every second year. And this year it’s again time to visit the big Oracle gathering in San Francisco. The big difference this year is that I’m going to be a speaker. Kind of scary, but I’m really looking forward to the experience. My session “Performance doesn’t happen by […]

I’m speaking at Tech14 in Liverpool in December

I just got an email confirming my presentation “Performance doesn’t happen by accident: Database performance for developers” at UKOUG Tech14 in Liverpool in December. This is my first presentation in the UK, and my first time attending the Tech conference. I’m really looking forward to this experience.