Oracle Scratchpad

August 3, 2009


Filed under: Advertisements — Jonathan Lewis @ 8:08 pm BST Aug 3,2009

I’ve been too busy to respond to comments on the blog for the last few days – apologies to all who have contributed, I might had some time to catch up on Thursday when I get home – but it’s hard to pass up the opportunity to point people in the direction of a little article that gave me a warm feeling of a job well done.

Warning – if you don’t want to read a description of how truly amazing I am, don’t follow this link.


  1. Hope to be like you when I grow up! :D

    Or at least humble as you! ;)

    Comment by lascoltodelvenerdi — August 4, 2009 @ 6:59 am BST Aug 4,2009 | Reply

    • I believe it was Churchill who once said of Clement Attlee:
      “Clement is a very humble man … of course, he does have a lot to be humble about”.

      Comment by Jonathan Lewis — August 6, 2009 @ 4:57 pm BST Aug 6,2009 | Reply

      • I don’t know why, but when someone cite Churchill, I get the feeling that I said something wrong… ^_^

        Comment by lascoltodelvenerdi — August 7, 2009 @ 6:55 am BST Aug 7,2009 | Reply

        • lascoltodelvenerdi,l

          Not at all – it’s just that I always feel that public claims to brilliance or humility both merit satirical responses.
          (If I just had a little humility I’d be perfect). ;)

          Comment by Jonathan Lewis — August 7, 2009 @ 7:10 am BST Aug 7,2009

  2. I’m curious what was the case mentioned in the blog? Something like Manual Optimisation?

    Comment by Timur Akhmadeev — August 4, 2009 @ 4:17 pm BST Aug 4,2009 | Reply

    • Timur,

      It was several years ago, so I really can’t be sure of the details.

      Graham’s blog quotes me as asking “Will the data always be ordered by field x when queried?”. Combined with the nature of the application (bulk loading, telecomms, time-based) I think this means I probably suggested using Index Organized Tables (IOTs) instead of heap tables, using time-based partitioning, using the optimum strategy for bulk-loading such objects.

      Comment by Jonathan Lewis — August 6, 2009 @ 5:22 pm BST Aug 6,2009 | Reply

  3. When I followed the link I was very happy to read its content. Because several years ago, when Jonathan Lewis was not as known as he is today, I have imagined myself in the same situation as Graham Oakes has been after having met Jonathan during this 60% performance fixe
    Immediately after having bought Practical Oracle 8i and have realized how it is not only technically very interesting but above all how it has been elegantly written, I realized that working with Jonathan will make a big step in my oracle mastering process.
    So, in order to realize the situation I have imagined myself in, I sent an e-mail to Jonathan asking if I can work with him for only one month. Unfortunately, he answered that it has been a long time that he has not been two or three consecutive days in a same client site.
    Then, I tried a second chance. I was working on a big project where we were facing severe performance problems; we have tried every thing by guessing and not by understanding the root cause of the problem. When the performance problem became recurrent, I have proposed to the customer inviting Jonathan for two days in order to fix the performance problem we have (kind of Graham Oakes situation). The customer refused my proposition and two years after that the project has been stopped and replaced by new external software.
    I am still hoping that, one day, the situation I have imagined will be reality

    Comment by Mohamed — August 4, 2009 @ 6:49 pm BST Aug 4,2009 | Reply

  4. Indeed! I hope to know how truly amazing you are.
    I hope… learn method of measuring, testing and proving a solution and blah blah from your blog.


    Comment by Surachart Opun — August 4, 2009 @ 7:18 pm BST Aug 4,2009 | Reply

  5. You are the best, I would be the happiest person if I would ever become 1% alike you. Thanks somuch for being here and guiding us with your wisdom and knowledge.


    Comment by Aman Sharma — August 5, 2009 @ 5:54 am BST Aug 5,2009 | Reply

  6. I think it’s about time you had a crack at World Peace. I’m sure you could manage it.

    (I don’t know … just how many emoticons and acronyms would I need to throw in here before people would know whether I was joking or not?)

    Comment by Doug Burns — August 5, 2009 @ 7:27 am BST Aug 5,2009 | Reply

  7. God give me patience – and give it to me NOW!
    God give me humility – and MORE than anyone else!
    It’s a hard one.
    When you know more than many, do you hide it for being humble, or show it so you can teach?
    Seeing as you teach so much, Jonathan, just keep going.

    Comment by mwidlake — August 7, 2009 @ 10:30 pm BST Aug 7,2009 | Reply

RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Powered by