Category Archives: Java

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

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 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.

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

End To End Metrics: A bridge between the developer and the DBA

First time I heard about end-to-end metrics was in a presentation given by Cary Millsap. The name of the presentation was “Thinking Clearly About Performance”. The presentation was great. One of the quotes that I really enjoyed was “Performance does not happen by accident! It’s a feature.”. One of the main topics in the presentation […]

OOW: Resolving Child Cursor Issues Resulting In Mutex Waits (Martin Klier)

PDF When talking about parsing we’ve been talking about different parsing scenerarios as hard parse, soft parse, softer soft parse and no parse. What was very interesting in this presentation was the introduction of a new parse scenario which he called the harder soft parse. This scenario is caused by the new feature in 11g […]

So many DBAs; yet so many performance problems

There are many applications and databases around, performing and scaling just as supposed to. We very seldom hear about these project. Of course, this could be small applications with small loads; or, on the other hand, this could be well design application with well written code, and well maintained databases. Yet there are so many […]