Category Archives: DBA

Nice blog about DBMS_METADATA from Alex Nuijten

This blog post has been laying in my TO_READ folder for a long time. Finally found some time to catch up, and I especially liked the little piece of PL/SQL for remapping the schema.

OOW16 – Are we failing or will performance rise?

The last session I attended at OpenWorld 2016 was “Thinking Clearly About Database Application Architecture”. A panel discussion with Toon Koppelaars, Cary Millsap, Gerald Venzl, Bryn Llewellyn and Connor Mcdonald. The panelists promotes that the business logic should be moved into the database, and implemented using PL/SQL. And yes – I do get the message, but I just […]

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 […]

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 […]

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! […]

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 […]

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: http://www.confio.com/logicalread/performance-improvements-with-oracle-11g-data-types/#.UnjEqBD-5Ag

11gR2: “Unlucky” combination of a new feature, a fix, application design and code

Sometimes a new feature (and/or a fix) could give some very unexpected results. In this article I’ll show how a mix between a 11g new feature (Adaptive Cursor Sharing), a fix (in 11.2, the obsolete threshold), application design (a separate schema for every customer), and code issues (not prefixing objects with schemaname, and bind datatype […]