Sometimes it’s alright to be LAZY – Part 1

vagrant04The best system administrators and developers I know are down right lazy. In a good way of course. They are experts in finding ways to work smarter. If they have to do it more than twice they consider to automate the task. I have worked with Oracle more than 15 years, and I don’t know how many times and hours I have spent installing operating systems, Oracle software and creating new databases. Not because I thought it was so darn fun, but because I needed the installation for some reason.

Thanks to tools like VirtualBox, Vagrant and, the time I have to spend on these task is almost down to zero. If you haven’t heard about these tools yet, you better keep on reading. I’m also doing a presentation at the Tech15 conference in Birmingham, England, in December this year. If you find this interesting and you’re there – please drop by my presentation and say hello!

Continue Reading »

SQL Developer Extension: Keep Alive

A “nice to have” extension for SQL Developer:

Template for creating data owners and application users

How many times haven’t I seen applications logging onto the Oracle database as the schema owner. This is definitely not good practice. And usually by the time the DBA discovers this, it’s “to late” to change. I’ve heard managers say: “It will be to expensive and to much of a risk changing this now”. (Note! The same manager actually argued the same when I asked them to – at least – change the password to something else than the username.)

The best way to actually change this is to talk to and educate your developers. In my company I created a script the developers could use when creating new schema users. The script is meant as a template, and should of course be changed if needed.

In the top of the script the developer chooses a application name, and some other settings:
Continue Reading »

Ora-600 when setting OCSID.DBOP tag with JDBC to a value larger than 29 byte

There is now a patch (17931569) for bug 18155614: “SR 3-9692688071 : Ora-600 when setting OCSID.DBOP tag with JDBC to a value larger than 29 byte

In version the following code fails with an ORA-00600 when ran in SQLPlus:
Continue Reading »

Old blog from Antognini regarding trace levels (10046)

Link to the blog:

Continue Reading »

Oracle 11g: New Locking behavior (modes) … an unexpected behavior. Or?

I just noticed some strange locking behavior in one of our production databases.

It took me a while to reproduce this in test. I’ve based my example on Richard Foots blog “Oracle11g: New Locking Modes When Policing FK Constraints (A Wolf at the Door)”.

Continue Reading »

How PL/SQL can help improve your application design, and a lot more

ora_plsqlAs an Oracle resource taking part in development projects I’ve had the change to see how PL/SQL can actually increase the quality of both the application development and in application maintenance. In this article I’ll try to share this experience, and show how using PL/SQL will increase the quality of your application and your Oracle databases.

Continue Reading »

Speaking at Oracle OpenWorld 2014, San Francisco

presentationThe 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 accident – Database performance for DBAs” was scheduled for Thursday at 09:30 at Marriott Marquis Hotel.

About 60000 attendees all together is rather impressive. But still it doesn’t feel to big. I meet friends and colleagues all over, and really get time to relax and enjoy between the sessions. And of course spend some time at the Exhibition Halls.

Continue Reading »