Skip to content

Author Archives Lasse Jenssen

Java (JPA): Improve statement caching efficiency with IN clause parameter padding

A nice little feature for handling queries with IN-lists, if you are using JPA. There are other and maybe better ways to solve this, but the solution described in the this blog could be worth a look into: How to improve statement caching efficiency with IN clause parameter padding

Posted 30 May 2018 § Hibernate § Java ‡ Comments (0) °

Why use Oracle Trace?

Oracle Trace is one of my favorite tools when working with performance. It’s not my only tool, but it’s a tool which have given me great success when working on performance related issues. In this small article I’ll try to explain why? I’ll start by telling a small story.

Posted 08 July 2017 § Oracle § Trace ‡ Comments (0) °

UKOUG Tech 16: Birmingham here i come!

The UKOUG Tech16 in Birmingham is getting close, and I really looking forward to this great event which I’ve been attending the last 3 years. In my experience there a lot of great presentations to attend, and a lot of interesting speakers and attendees to interact with. This year I get the opportunity to give two […]

Posted 30 November 2016 § Oracle ‡ Comments (0) °

SQL Developer Extension: Keep Alive

A “nice to have” extension for SQL Developer: https://github.com/scristalli/SQL-Developer-4-keepalive/wiki/English-guide

Posted 03 August 2015 § SQL Developer ‡ Comments (0) °

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

Posted 13 June 2015 § DBA § Java § Oracle § Script § SQL ‡ Comments (0) °

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 12.1.0.1 the following code fails with an ORA-00600 when ran in SQLPlus:

Posted 27 May 2015 § 12c New Features § MethodR § Oracle ‡ Comments (0) °

Old blog from Antognini regarding trace levels (10046)

Link to the blog: http://antognini.ch/2012/08/event-10046-full-list-of-levels/

Posted 27 May 2015 § 11g New Feature § Oracle § Performance ‡ Comments (0) °

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

Posted 14 January 2015 § 11g New Feature § Database Design § Internals § Performance § SQL ‡ Comments (0) °