Oracle Scratchpad

April 27, 2009

Summary Stats

Filed under: Site History — Jonathan Lewis @ 7:01 pm BST Apr 27,2009

As I write this post my page view counter has just clicked past the “magic million” marker – so I thought it was time to update the previous summary of what’s been of most interest to visitors:

If we look at the complete lifetime of the blog, the top five are:

Cartesian Merge Join 14,982
Bind Variables 11,474
dbms_xplan in 10g 10,719
NOT IN 10,661
Index Rebuild 10g 8,811

But restricting view to just the last year this changes a little to:

NOT IN 7,351
Index Rebuild 10g 6,636
Cartesian Merge Join 6,626
dbms_xplan in 10g 5,959
SQL Profiles (10g) 5,010

Of course – while 1,000,000 sounds like quite nice landmark figure to me – I can always put things into perspective by remembering that one of my clients had already reached a rate of 1,000,000 page hits in five minutes several years ago; and then there’s a video on of Susan Boyle performing for “Britain’s Got Talent” that clocked up more than 42 million views in less than a week.


  1. Dear Jonathan,


    I know you are a honest man, so this one million is real. How many weeks old is your blog?

    Comment by Harald van Breederode — April 28, 2009 @ 6:15 am BST Apr 28,2009

    • Harald,

      Thank you,

      The blog is very close to 30 months old – which means an average of about 33,000 page views per month.

      Typically this is 1200 to 1700 views per day on weekdays, and 200 to 500 views per day at week-ends.

      Comment by Jonathan Lewis — May 2, 2009 @ 6:50 am BST May 2,2009

  2. One mil…! :-o

    I’m just at 18.200 after one year!

    I must work harder…and write in English! ^_^

    Congratulations Jonathan!

    Well in the last year there was an explosion of “NOT IN” and Index rebuilding.

    “Problems” with Oracle 10g?

    Comment by lascoltodelvenerdi — April 28, 2009 @ 6:56 am BST Apr 28,2009

    • lascoltodelvenerdi,

      “Problems” with 10g – I think the last time I posted the stats (at 500,000) I pointed out that there was a sudden jump in March 2008 in the in interest in three or four pages that looked like things you would see more often in 10g.

      Comment by Jonathan Lewis — May 2, 2009 @ 6:52 am BST May 2,2009

  3. Congratulation !!!

    Comment by Asif Momen — April 28, 2009 @ 8:45 am BST Apr 28,2009

  4. One million may have no intrinsic meaning, but celebrating “a lot” does. What mean “a lot” is quite subjective, but certain powers of ten is somewhat agreeable to most people today, and given value because of that alone.

    Jonathan, you have an excellent blog. Congratulations of passing this milestone.

    Comment by Brian Tkatch — April 28, 2009 @ 12:44 pm BST Apr 28,2009

  5. Congratulations Jonathan!!

    Comment by Amit — April 28, 2009 @ 4:51 pm BST Apr 28,2009

  6. Congratulations.

    I don’t think you need stats/numbers to substantiate your contribution to the community. At least not anymore.


    Comment by Ganesh Vaidhya — April 28, 2009 @ 5:59 pm BST Apr 28,2009

  7. Felicidades! leemos tu blog desde centroamerica!
    Excelente blog.

    Comment by carcasco — April 28, 2009 @ 8:45 pm BST Apr 28,2009

  8. […] always readable Jonathan Lewis celebrates his millionth visitor by comparing himself to Susan Boyle. For this milestone, Jonathan deserves a kiss, too, don’t […]

    Pingback by Log Buffer #144: a Carnival of the Vanities for DBAs | Pythian Group Blog — May 1, 2009 @ 4:19 pm BST May 1,2009

RSS feed for comments on this post.

Website Powered by

%d bloggers like this: