Skip to content

Author Archives Lasse Jenssen

Scripts: Tanel Poder´s TPT script out on GitHub

Tanel Poder have uploaded his TPT script to GitHub. If you have never looked as his script I highly recommend spending some time on them. You’ll find them at: https://github.com/tanelpoder/tpt-oracle

Posted 28 June 2018 § Oracle ‡ Comments (0) °

Java: JDBC roundtrips are expensive

SQL Daily just tweeted about the fact that JDBC roundtrips are expensive. This is something many developers either forget or do not know. I have seen so many chatty applications killing the application performance, and the database performance. Toon Koppelaars have performed some excellent presentations showing this. Lukas Eder have also written some nice articles […]

Posted 28 April 2018 § Java § Performance ‡ Comments (0) °

Java: Nice article about Java, Time and Dates

I really enjoyed the following article about Java, Time and Dates: https://yawk.at/java.time/ From the article: An introduction to java.time Time is a complex topic. Many programmers are unfamiliar with the difficulties and common bugs associated with time. This has in the past lead to time APIs that allowed “sloppy” code which can lead to bugs in […]

Posted 28 April 2018 § Java ‡ Comments (0) °

PLSQL: Using Datapump API with filter on multiple tables

The developers in one of the teams I work within wanted to export the tables in a schema with limited number of rows. This could of course be done by running  expdp command line.  But this time we needed to find the last x numbers of primary keys in one of the central tables and […]

Posted 27 July 2017 § Oracle § PL/SQL ‡ Comments (0) °

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.

Posted 04 May 2017 § DBA § Oracle § PL/SQL § SQL ‡ Comments (0) °

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

Posted 23 September 2016 § Architecture § DBA § DevOps § Java § Oracle § Performance ‡ Comments (0) °

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

Posted 09 September 2016 § DBA § DevOps § Java § Oracle ‡ Comments (0) °

Books to read: “Mastering Oracle Trace Data, Second Edition” with Cary Millsap

The “Mastering Oracle Trace Data” from Cary Millsap is a great book about performance in general, and about how to work with trace data. The second edition have several new chapters adding valuable knowledge to both developers and DBAs. This is one of the books that you really should have in your bookshelf.

Posted 05 August 2016 § Books to read § MethodR § Oracle § Performance ‡ Comments (0) °