|9th – 10th Sep 2015||Zurich, Switzerland: Christian Antognini is chairing his annual event on Oracle Performance and has asked me to deliver a couple of presentations. I’ll be speaking on “Calculating Join Cardinality” and “Understanding Parallel Execution Plans”. Full speaker list and agenda at this URL.|
|16th Sep 2015||Online: Date to be confirmed (may be 15th or 17th): John Goodhue will be setting things up to run an online webinar – 90 minutes at 1:00 pm (BST) 7:00 pm (BST). The title is “Creating Test Data To Model Production Problems.”
Although it takes some effort to create highly realistic models of production activity, we’ll also look at simple ways of modelling some aspects of concurrency, and show how concurrency can make a massive difference to what goes on inside the database – time permitting we will take a look at a few dumps of internal structures (disk and memory) to highlight some of the effects of concurrency.
|30th Sep 2015||Online: Date to be confirmed (may be 29th Sept or 1st Oct): John Goodhue will be setting things up to run an online webinar – 90 minutes at 1:00 pm (BST) 7:00 pm (BST). The title is “Five Hints for Optimising SQL.”
Adding hints to production code is a practice to be avoided if possible, though it’s easy to make the case for emergency patching, and also as the basis for a method of generating SQL Plan Baselines. However, notwithstanding (and sometimes because of) the continuing enhancements to the optimizer, there are cases where the only sensible option is to constrain the broad brush strategy that the optimizer can take in a way that allows it to find a reasonable execution plan in a reasonable time.
In this presentation we examine five of the “classic” hints that I believe are reasonable tactical weapons in the battle to beat the optimizer – (no_)merge, (no)_unnest, (no_)_subq, (no_)push_pred, and driving_site(). We will also glance briefly at a couple of other useful hints along the way.
|5th – 9th Oct 2015||Johannesburg, South Africa: Oracle University is organising an Expert Summit event, and has asked me to be one of the speakers. I’ll be on for the first two days with the titles: “Writing Optimal SQL” and “Trouble-shooting and Tuning”.|
|25th – 29th Oct 2015||San Francisco, USA: The abstracts I submitted for OpenWorld have all been declined, but it’s fairly safe to assume I’ll show up, and I have a degree of confidence that the OakTableWorld selection committee will accept at least one of my abstracts.|
|17th – 19th Nov 2015||Nuremberg, Germany: I’ve had two abstracts accepted for the DOAG annual conference – “Five Hints for Optimising SQL” that I presented recently for Oracle Midlands (See Tim Hall’s comments here), and “Core Strategies for Troubleshooting”.|
|7th – 9th Dec 2015||Birmingham: UKOUG Tech Conference 2015. My abstract on optimising by not doing the work you don’t need to do (“Just don’t do it”) has been timetabled for Tuesday 8th, and I’ve been given a single combined panel session on the Cost Based Optimizer (rather than one for beginners and one for the more experienced) for Monday 7th. I’ll be sharing the platform with Maria Colgan, Chris Antognini, and Nigel Bayliss (a recent addition to Oracle’s Data Warehousing group in the UK).|
|1st – 5th Feb 2016||London, UK Provisional: Oracle University is organising an Expert Summit event, and has asked me to be one of the speakers.|
|10th – 11th May 2016||Berlin, Germany: (provisional) Oracle University is organising an Expert Summit event and has asked me to be one of the speakers. I’ll be presenting: “Trouble-shooting and Tuning” and “Writing Optimal SQL” and .|