Tony’s Oracle Tips


Welcome to my Oracle blog and here are the Posts.

The slides for my UKOUG Tech14 presentation All about joins can be downloaded here.

The UKOUG Tech14 quiz is now closed.

Quiz questions.

Here are the answers:

Quiz answers

My book Expert Oracle SQL is out now! This book has over 600 pages to help you understand how to tune SQL statements and manager statistics in a runtime environment. See your country’s Amazon website for more details.

I do not blog on a regular basis.  Only when I find something interesting to say that doesn’t seem to be available elsewhere.  So if you are interested in what I have to say why not set up an RSS feed or use the “Follow” button on the right?

You will see pages on the right that provide links to my published articles, contact details and so on.

The UKOUG 2012 national conference presentation “Star Transformations” can be found here:

The UKOUG 2012 national conference presentation “The MODEL clause explained” can be found here:

The material for my beginner’s guide to SQL tuning presented at the UKOUG 2011 national conference can be found here:

The material for my UKOUG Stabilising Statistics talk can be found here:

The script for my UKOUG Index Clustering Factor Deep Dive talk can be found here:


The powerpoint presentation is here:


Note:  The script from my talk “Advanced SQL for PL/SQL Programmers” at the UKOUG 2008 national conference and the 2009 Scottish Conference can be found here:


The powerpoint presentation can be found


To use this script you will need to create a suitably privileged account called “SCOTTBIG”.  Good luck!

By the way: the reason the example that performs aggregates using analytic functions runs so slowly is (as I suspected) because of the unused columns.  Replace ‘*’ with a smaller number of columns and it runs like a champ!


  1. Good to know another very useful blog. I thoroughly recoommed the presentations here. Having got intruduced to Tony through work, his expertise in Oracle and his patience in explaining complex scenarios is exemplary.


    Comment by Mich Talebzadeh — November 8, 2012 @ 8:47 pm | Reply

  2. In your book Expert Oracle SQL you mention Are you sure link is a blog by Martin Amis? And not a blog by Anton Scheffer, working for Amis Services?

    Comment by Anton — October 20, 2014 @ 7:42 pm | Reply

    • Anton,

      My humble and sincere apologies for the misattribution of this famous blog.

      If you e-mail with a suitable correspondence address I would be happy to send you a signed copy of my book.

      Comment by tonyhasler — October 21, 2014 @ 10:27 pm | 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. Create a free website or blog at


Get every new post delivered to your Inbox.

Join 65 other followers

%d bloggers like this: