Oracle Scratchpad

Public Appearances



11th/12th June 2018 Vienna, AustriaThe call for papers is still open (closing date 1st March) for the 30th Anniversary Conference of the Austrian Oracle User Group, and I’ve submitted a few abstracts: “Just Don’t Do It” (Examples of how to avoid making the database do unnecessary work), “Reading Parallel Execution Plans”, and “Histograms in 12c – faster and more accurate”.
21st June 2018 Edinburgh, Scotland: The call for papers is still open (closing date 26th February) for OUG Scotland 2018 and I’ve submitted a couple of abstracts: “Struggling with Statistics” (a shorter version of the presentation I’ve prepared for Trivadis in September) and “Partitioning Enhancements in 12c Release 2”
19th/20th Sept 2018 Zurich, Switzerland: I’ll be speaking at the Trivadis Performance Days along with several of the mostly highly skilled and well-informed individuals in the Oracle arena. The topic I’ve suggested is: “Struggling with Statistics” (a longer version of the presentation I’ve offered to OUG Scotland):

When someone requests help on the Oracle forums to address the problem of a query picking a bad execution plan, one of the commonest (and most rapid) responses is the suggestion to make sure the statistics are up to date. Sometimes this will solve the problem, sometimes it won’t solve the problem but will produce a change that makes it easier to identify the problem, sometimes it just won’t help at all.

“Up to date” statistics, “accurate” statistics and histograms aren’t necessarily what you need to get Oracle to produce the execution plan you want, and in this presentation we look at some of the ways in which “good” statistics are not “good enough”, and come up with some strategies for recognising when we have to work around Oracle’s statistics and how we can work around them with the minimum of effort and risk.

3rd – 5th Dec 2018 Liverpool, UK: The UKOUG Annual Conference Tech 18 will be held in Liverpool this year. The call for papers isn’t open yet, but I can’t imagine not putting in a couple of abstracts: and I’ll probably be a bit upset if I fail to get a speaking slot. It is possible to register your interest at the UKOUG website

Leave a Comment »

No comments yet.

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

Powered by