Oracle Scratchpad

Public Appearances

2nd – 3rd Jun 2016 The Netherlands: I’ll be presenting two topics at the  AMIS 25 conference, a masterclass (90 minutes – split into two consecutive sessions of 45 minutes) on “Understanding and Manipulating Parallel Execution Plans”, and a more traditional session called “Just Don’t Do It” – a collection of real (though camouflaged) cases of reducing the workload by constructing (uncommon or even non-standard) SQL that tries to avoid the work that doesn’t need to be done.
22nd Jun 2016 Glasgow, Scotland: The annual OUG Scotland conference is due to be held at the Radisson Blu hotel in Glasgow. I’ll be giving my “Just Don’t Do It” presentation and chairing a panel on “Optimisation” (which won’t just be limited to the Cost Based Optimizer).

On the panel we will have: Carl Dudley (12c New features), Joze Senegacnik (Efficient SQL), Kai Yu (ASM CFS for Cloud) and Heli Helskyaho (SQL Developer), so there’s plenty of scope for asking questions which AREN’T just about the optimizer.

Early July 2016 Birmingham, UK: (Provisional) I’m planning to do an evening session for Oracle Midlands. Topic to be decided.
18th – 22nd Sept 2016 San Franciso, USA: . I’ve submitted an abstract for OpenWorld 2016 – and I’ll probably be attending even if it’s not accepted. The abstract title is: “Indexing and the impact on New Technologies”, the abstract is as follows:

Over the last 8 years there have been many dramatic changes to the technology underpinning the Oracle RDBMS. We have Exadata systems, in-memory columnar storage, container databases, and the move to Cloud computing.

Despite these advances we still aim to make the most cost-effective use of the technologies we’ve chosen, and for critical systems that still means selecting the best indexing strategies – even if, in some cases, the best indexing strategy turns out to be “don’t bother”.

In this session we examine how different technologies affect how we index to minimise the workload and maximise the benefit of the technology. The fundamental questions hardly change but an examination of the unique selling points of each feature shows us variations in the cost/benefit analysis that can make a big difference to our choices.

The session will start with a 15 minute introduction to the topic, followed by 30 minutes of Q&A

28th – 29th Sept 2016 Zurich, Switzerland: . I will be speaking at Trivadis’ annual event, this year called “Database Development and Performance Days” and consisting of two streams. My topics will be: “Just Don’t Do It” – examples of optimising your code by avoiding the work you didn’t need to do, and “Indexing” – a discussion of the benefits we hope to get from indexes (B-tree and Bitmap), why we don’t always get then, and what it costs to try.
5th – 7th Dec 2016 Birmingham, UK: I’ve submitted four proposals for UKOUG Tech 16.

  1. The panel session on the Cost Based Optimizer that went down so well last year – with Neil Chandler and Martin Widlake acting as MCs
  2. Indexing and the Impact of New Technologies – the abstract I’ve also submitted for OpenWorld (see above)
  3. All about B-tree and Bitmaps – a masterclass (2 hours) on indexes: with (if I get a repeat of the 2012 session) lots of audience participation).
  4. Interpreting Parallel Execution Plans – a masterclass (2 hours) that starts where typical presentations on reading serial execution plans end.

I’ll also be around for “Super Sunday” on 4th Dec – but I haven’t submitted a specific abstract for that.


  1. Hi Jonathan, is there a plan for any online event? That would be very useful to attend virually.

    Comment by orausern — December 8, 2015 @ 5:05 pm BST Dec 8,2015 | Reply

    • Orausern,

      I’m working on rewriting my day-long seminar on Execution plans; should be ready early Feb, to be broadcast in 4 separate sessions so you don’t have to listen to the whole thing in one go.

      Comment by Jonathan Lewis — December 9, 2015 @ 3:55 pm BST Dec 9,2015 | Reply

      • Hi Jonathan,
        Any idea when you will be posting schedule of your online webinars?

        Comment by Amir Hameed — March 2, 2016 @ 6:22 pm BST Mar 2,2016 | Reply

  2. Hi Jonathan,
    That is great news! Looking forward to know the dates!!

    Comment by Nirav — December 16, 2015 @ 7:21 pm BST Dec 16,2015 | Reply

  3. I really enjoy the material you have on your web site it extremely has helped me out a whole lot thanks

    Comment by Britt Hampel — March 26, 2016 @ 7:22 pm BST Mar 26,2016 | 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 6,323 other followers