Skip to content

Category Archives: DBA

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

Posted 07 November 2013 † Lasse Jenssen § 11g New Feature § Performance § PL/SQL ‡ Comments (0) °

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

Posted 10 May 2013 † Lasse Jenssen § 11g New Feature § Architecture § Database Design § Java § Oracle § Performance ‡ Comments (0) °

New feature 11g: DBMS_SQLDIAG to dump 10053 trace

Almost everyday I learn a new 11g feature. Today I found this way to dump a 10053 trace for a existing cursor. I wanted to get a 10053 trace on a query already in library cache. I did not want to flush shared pool. I was thinking about gathering statistics with NO_INVALIDATE=false. But this was […]

Posted 19 April 2013 † Lasse Jenssen § 11g New Feature § Oracle § Performance ‡ Comments (0) °

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

Posted 01 April 2013 † Lasse Jenssen § 10g New Features § 11g New Feature § Java § Oracle § Performance ‡ Comments (0) °

Article: Faster Batch Processing and Logging by Mark rittman

I just read this article about efficient error handling when running batch jobs. This is somethink many DBAs and developers should put on their mind, and consider using next time they’re planning to do dataloads or batch jobs.

Posted 20 November 2012 † Lasse Jenssen § 10g New Features § PL/SQL § SQL ‡ Comments (0) °

Running Toad under wine in Ubuntu linux

Finally I got a description on how to run Toad for Oracle under wine in linux. The description is not quite “out-of-the-box”, but with a little fiddeling around I got it to work: http://toadworld.com/Blogs/tabid/67/EntryId/951/Toad-11-6-Runs-Natively-on-Linux.aspx I had to remove wine, and install the 1.4 version (just upgrading from 1.3 to 1.4 did not work). Then I […]

Posted 09 November 2012 † Lasse Jenssen § Linux ‡ Comments (0) °

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

Posted 19 September 2012 † Lasse Jenssen § Architecture § Database Design § Java § Oracle § Performance ‡ Comments (0) °

Flashback Session … that was cool! Thanks mate!

Today my ass was saved by my good friend and colleague, Lars Johan Ulveseth. Thanks mate! Yes I messed up … just a little … in a test environment. But it could have made a lot of mess.

Posted 25 May 2012 † Lasse Jenssen § Oracle ‡ Comments (0) °