Oracle Scratchpad

Public Appearances

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 of 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.
17th – 21st Oct 2016 Slovenia and Croatia: . I’ve been asked to speak at the Slovenian and Croatian user group events which occur back to back over the week of 17th October. I’ve offered “Just Don’t Do It” and a short version of “Interpreting Parallel Execution Plans” for both events.
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, though I might end up doing the “Indexes and the impact of New Technology” presentation.

If the panel session is selected you’ll be able to email me questions in advance at


  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,551 other followers