Author Archives

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.

I’m speaking at Oracle OpenWorld 2014, San Francisco, in September/October

I’ve just registered in this years OpenWorld conference in San Francisco in september. Last time I attended was in 2012. The news this year is that I’m going to be a speaker. My call for paper “Performance doesn’t happen by accident: Database performance for DBAs” just got accepted. Look for session id CON1918. Hope to see […]

Isolation Levels by Tom Kyte

I just reread the Oracle Magazine article by Tom Kyte named “On Transaction Isolation Levels” from November 2005. Great article that really explains why your relational database can not be treated as a black box. From the article: “The ANSI/ISO SQL standard defines four levels of transaction isolation, with different possible outcomes for the same […]