Tony’s Oracle Tips

Welcome!

Welcome to my Oracle blog and here are the Posts.

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:

http://tonyhasler.files.wordpress.com/2012/12/star-transformations.pptx

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

http://tonyhasler.files.wordpress.com/2012/11/the-model-clause-explained.pptx

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

beginnerstuning.zip

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

stabilising_statistics.zip

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

clustering_factor.sql

The powerpoint presentation is here:

index_clustering_factor_deep_dive.ppt

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:

advanced_sql_for_plsql_programmers.sql

The powerpoint presentation can be found
here:

advanced_sql_for_plsql_programmers.ppt

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 Comment »

  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.

    Mich

    Comment by Mich Talebzadeh — November 8, 2012 @ 8:47 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:

WordPress.com Logo

You are commenting using your WordPress.com 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 WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 33 other followers

%d bloggers like this: