• Careful in 11.2 with dbms_utility

    Its common to have an instrumentation infrastructure where you might be calling DBMS_UTILITY.FORMAT_CALL_STACK to record where in the code path you may be.. But this can bite you in 11.2 A simple demo of how much slower it has become is shown below. Relevant parameters are below: NAME VALUE —————————————- ————- plsql_ccflags plsql_code_type INTERPRETED plsql_debug Read more

  • Oracle Certification

    Is doing the OCP exams worthwhile ? Yes, but not for the reasons you may be thinking. The OCP exams are a relatively cheap way of identifying possible weaknesses in your knowledge base on Oracle. For example, when I did the OCP, all of the database sites I had worked on did not use MTS Read more

  • Openworld – Tuesday / Wednesday

    Tuesday was dedicated to attending sessions.  Most were good, but there is that unfortunate thing when speakers are employees of Oracle.  You can tell by the occasional snippet of information that they are very sharp and very passionate about what they want to talk about, but that’s not necessarily what they’ve been given on the Read more

  • Openworld – Thursday

    Spectacular organisation by the Ace Director team (Lillian and Vikki) meant that my exit from San Fran went just as smoothly as my entrance.  A fantastic week. So – its all about “c” now, Cloud Cloud Cloud. On the last day, I saw some great sessions on security and migrating to Exadata.  The main hassle Read more

  • Oracle Openworld – Monday

    Welll, today was a bit of a selfish day.  Didn’t really want to spend time on sessions etc, because I had my own session to give, and seeing as its been 7 years since I’ve given a talk at OOW, I wanted it to be “just right”.  So this morning was spent pretty much in Read more

  • Hello world!

    Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging! Read more