Oracle Scratchpad

December 10, 2012

Viewing Figures

Filed under: Site History — Jonathan Lewis @ 10:51 am GMT Dec 10,2012

It’s time for another landmark. The blog hit 3,000,000 views on 30th November  – but I’ve been too busy to do my usual analysis of posts. The latest half million took 42 weeks (five weeks less than the previous half million increment) and here are the latest stats on popular views:

First the top five across the lifetime of the blog (excluding the home page and opening menu) and the old faviourites haven’t changed:

AWR / Statspack menu 57,477 Updated from time to time
NOT IN 40.952 Feb 2007
Cartesian Merge Join 33,367 Dec 2006
dbms_xplan in 10g 33,279 Dec 2006
SQL Profiles (10g) 25,219 Feb 2007

If we look at just the last year, the top five are:

AWR / Statspack menu 19.307 Updated from time to time
Oracle Core 9.996 Dec 2011
Shrink Tablespace 8,788 Feb 2010
AWR Reports 8,548 Feb 2011
NOT IN 8,026 Feb 2007

A couple of old favourites (dbms_xplan in 10g and SQL Profiles (10g) have finally fallen off the top slots, and Cartesian Merge Join didn’t make it back after slipping last year – but it’s interesting (and not entirely surprising) to see how NOT IN is still coming up after so many years.

The other statistic of note is the number of followers the blog has, currently 1,197 (although it was 1,185 on 30th Nov – I probably picked up a few more immediately after the UKOUG annual conference).



  1. Google reader says, that the blog has 7 907 subscribers :)

    Comment by Sayan Malakshinov — December 10, 2012 @ 10:54 am GMT Dec 10,2012 | Reply

  2. That’s due to the fact that wordpress ignore rss subscribers :-)

    Comment by bdrouvot — December 12, 2012 @ 8:51 pm GMT Dec 12,2012 | Reply

  3. […] figures for the previous half million views (opens in a new window) are similar for most of the top 5, although last year had a big spike for […]

    Pingback by Viewing Figures | Oracle Scratchpad — October 8, 2013 @ 5:47 pm BST Oct 8,2013 | Reply

RSS feed for comments on this post. TrackBack URI

Comments and related questions are welcome.

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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Website Powered by

%d bloggers like this: