Oracle Scratchpad

Public Appearances

27th Sept – 2nd Oct San Francisco: I have been invited to do a 45 minute presentation at OpenWorld with the title Reading an AWR Report. I’ll also be speaking about Calculating Selectivity at Oak Table World, and then at the EOUC “Short Talks” sessions I’ll be doing 5 minutes on Upgrading to 12c – what will it break. I’ve also told the people from Delphix that I’ll be happy to do a couple of sessions on their stand, say a few words about why I like their product.
14th – 15th Oct Munich (Germany): I’ll be running a two-day course covering “Writing Optimal SQL” and “Trouble-shooting and Tuning” under the University “Celebrity Seminars” banner. Further details at this URL
20th – 23rd Oct Nordic Tour: I’ll be joining the OTN Nordic Tour – which is going to be a whirlwind visit to Stockholm (Sweden), Oslo (Norway), Copenhagen (Denmark), and Helsinki (Finland) in that order. I’ve got two topics on the agenda: Understanding and Optimising Parallel Queries, and Reading an AWR Report. Further details at this URL.
5th – 6th Nov Istanbul, Turkey: I’ll be running the two-day seminar “Optimising Oracle – Foundations” for Oracle University as part of their “Celebrity Seminar” series. Further details at this URL.
18th – 20th Nov Nuremberg, Germany(provisional): DOAG Annual conference – I should be able to get there this year and join in on the “Oak Table” stream which was such a success last year. I’ve sent in three abstracts, and now I’m waiting to hear the results.
7th – 10th Dec Liverpool: The UKOUG Tech Conference is in Liverpool this year; I’ve got three sessions (more like one short and one long, though) in the main conference and one “Oak Table Sunday”.Titles and (provisional) times are:

  • Calculating Selectivity:  Sunday 13:30 – 14:20
  • Five hints for Efficient SQL:  Tuesday 17:30 – 18:20
  • Fundamentals of Troubleshooting (without graphics) pt.1 Wednesday 09:00 – 09:50
  • Fundamentals of Troubleshooting (without graphics) pt.2 Wednesday 10:00 – 10:50

My presentation on “Understanding and Optimising parallel queries” is on the reserve list – so there’s always a chance that that will get in at the last minute.

15th Dec Munich (Germany): I’ll be running the one day course “Beating the Optimizer” under the Oracle University “Celebrity Seminars” banner. Further details at this URL


  1. Hi Jonathan,
    Are there any plans of you doing an apperance in Canada/Toronto?

    Comment by Lovell — November 16, 2012 @ 11:50 pm BST Nov 16,2012 | Reply

    • Lovell,

      No plans, although I have dropped in a couple of times over the last few years; but it tends to be a short trip while I’m doing something else.
      Maybe the next time I’m working in NY I could hop across the border for a few hours. (That’s how I managed to fit in a couple of sessions with the user group in Vancouver – I think one was day trip between my speaking sessions at OpenWorld, another was a day trip up from a gig I was doing in Seattle.)

      Comment by Jonathan Lewis — December 22, 2012 @ 5:34 pm BST Dec 22,2012 | Reply

  2. Hello Jonathan,

    I would really like you to visit us in Morocco, because we really need you to seminars.


    Comment by ZH — November 20, 2012 @ 9:30 am BST Nov 20,2012 | Reply

    • ZH,

      Whereabouts in Morocco – I visit Gibraltar from time to time, and Tangier is just the other side of the straits.
      Maybe you could get your local Oracle Rep to persuade Oracle University to do something there.

      Comment by Jonathan Lewis — December 22, 2012 @ 5:31 pm BST Dec 22,2012 | Reply

  3. Hi Jonathan,
    I would really like you to visit us in Pune,India. Personally i would like to attend your “Designing Optimal SQL” 2 day tutorial course/seminar.

    Comment by SP — January 4, 2013 @ 6:33 am BST Jan 4,2013 | Reply

    • SP,

      It’s been a couple of years since I attended AIOUG – I’m trying to reduce the number of long-haul flights I take each year, but maybe it’s about time I asked the ACE program if they would sponsor me to appear at AIOUG again.

      Comment by Jonathan Lewis — January 4, 2013 @ 1:22 pm BST Jan 4,2013 | Reply

      • Hi Jonathan,
        Hope everything falls in place so that i will HEAR from you. Thanks. Have a good day !! :)


        Comment by SP — January 5, 2013 @ 12:58 pm BST Jan 5,2013 | Reply

  4. Jonathan –

    Just want to say I loved your course on Indexes at Thompson Reuters in Eagan Minnesota! I do wish you come back next this year (2013) for more seminars.


    Comment by dswens01 — January 31, 2013 @ 12:52 am BST Jan 31,2013 | Reply

    • D,

      Thanks for the comment.

      Your wish is granted, by the way; I’ve just posted details of a couple of new courses I’ve just finished designing, and a couple of provisional dates for running them in Minneapolis. (Over the next few weeks we’ll be trying to set up a timetable for a few more visits for these, and the other courses, across the USA for the rest of the year.)

      Comment by Jonathan Lewis — January 31, 2013 @ 8:29 pm BST Jan 31,2013 | Reply

  5. Hi Jonathan,

    I really enjoyed your course last year. Do you have plan to come to Dallas area in Texas sometime in 2013?

    Comment by Jason — February 5, 2013 @ 5:49 pm BST Feb 5,2013 | Reply

    • Jason,

      Thanks for the comment.

      I don’t have any plans for Texas at present – but I’ve got a couple of days pencilled in for Minneapolis at the end of September, so I’ll be looking at finding a couple more days elsewhere while I’m in the USA – it’s too far to travel for just two days – so I’m open to suggestions.

      Comment by Jonathan Lewis — February 6, 2013 @ 7:22 pm BST Feb 6,2013 | Reply

  6. Hi Jonathan,

    Any plans of visiting Australia in the near future. Really keen to attend your sessions.


    Comment by Vijay — July 24, 2013 @ 4:05 am BST Jul 24,2013 | Reply

  7. Vijay,

    Not this year, but the China trip I had pencilled in for October has been merged with the OTN APAC tour, and I think I’ll be covering Japan and China. Unfortunately I don’t have time for the whole APAC trip which covers NZ and Australia – but I may be able to do that next year.

    Comment by Jonathan Lewis — July 24, 2013 @ 4:12 pm BST Jul 24,2013 | Reply

  8. Hello Jonathan,

    Happy to hear that you will be coming to Dubai in the first week of Feb next year. Anyways, will get in touch with nearest OU rep for further details.

    By the way, one of your book by name “Cost-Based Oracle Fundamentals” still happens to be one of my favorite book. Very detailed explanation about optimizers. I could say, those who moved from core-developers to DBA, this will really help in understanding the concepts of histograms and mainly the chapter of ‘Upgrade Headaches’ & 10053 trace file options.


    Comment by Ata — August 19, 2013 @ 11:37 am BST Aug 19,2013 | Reply

  9. Hi Jonathan,

    We would really like to attend your seminar in Dubai. But 3700$ needed for registration for the whole Oracle University event seems
    rather expensive ( to me at least). Can it be any alternative ways of attending your seminars in Dubai? I mean, is it necessary to visit the whole session
    and to pay the whole large price for five days, while we are particularily insterested only in your sessions.

    Thank you in Advance.
    Yours Sincerely, Evgeniy.

    Comment by Evgeniy — December 12, 2013 @ 1:51 pm BST Dec 12,2013 | Reply

    • Evgeniy,

      I don’t have anything to do with the arrangements that Oracle University make, I just show up and do the presentations. You’ll have to contact Oracle direct to see if there are any arrangements for attending part of the event. If you have friends in the same position a group effort might be the most effective thing to do.

      Comment by Jonathan Lewis — December 13, 2013 @ 6:03 pm BST Dec 13,2013 | Reply

RSS feed for comments on this post. TrackBack URI

Leave a Reply

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

You are commenting using your 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 )

Google+ photo

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

Connecting to %s

The Rubric Theme. Blog at


Get every new post delivered to your Inbox.

Join 3,905 other followers