Oracle Scratchpad

March 22, 2011

Visitors etc.

Filed under: Site History — Jonathan Lewis @ 12:00 pm BST Mar 22,2011

Well, I’ve finally reached another “landmark” number in the page views – 2,000,000 views (after four and a half years) – so it’s time for a little statistical summary for comparison with the last landmark.

Looking at just the results for the last 12 months, here are some numbers in different categories.

Page Views:

AWR / Statspack 11,871 Updated from time to time
NOT IN 7,981 Published February 2007
dbms_xplan in 10g 6,672 Published November 2006
Simple Scripts 5,899 Updated from time to time
Cartesian Merge Join 5,335 Published December 2006

Referrers (incoming links)

Google Reader 13,296 10,234 The OTN database forum. A large percentage for reading AWR, index rebuilds, or hints.
Google 6,079 80/20 split between the news groups and searches 3,691 The Oak Table site. Most from the aggregator 3,235 My old web page. Most are from the front page 2,330 Eddie Awad’s feed aggregator 1,849 A newsgroup history site. Most are for “How to read AWR”

Clicks (places my readers go to)

Oak Table home page 1,926
My old web page 1,377
Nigel Noble’s blog 1,961
Oracle’s Statspack paper(pdf) 1,238
Wolfgang Breitling’s home page 1,057
The 10053 treeviewer download 981
Graham Woods ASH presentation 936
Julian Dyke’s presentation page 929

Incoming Searches

There are harder to count, so I haven’t, but to demonstrate this – I’ve listed some of the most popular searches by the number of different variations that got to the blog, but I haven’t summed the related numbers of page views.

“Jonathan Lewis” / Scratchpad 23 variations
Oracle NOT IN 20 variations
SQL Profiles 18 variations
“some topic” + “jonathan lewis” or “scratchpad” 16 variations
Cartesian join 14 variations
free buffer waits 12 variations
dbms_xplan 12 variations
push_subq 11 variations


  1. Great job Jonathan!

    Too bad those page views dont convert into that many $$ :-) Anyways we are thankful for your hard work and effort.


    Comment by Sean — March 24, 2011 @ 8:39 pm BST Mar 24,2011 | Reply

  2. Great achievement Jonathan !

    Cheers and thanks for all the knowledge sharing !!!

    Comment by Amardeep Sidhu — March 25, 2011 @ 5:38 am BST Mar 25,2011 | Reply

  3. […] time for another landmark. The blog has just hit 2,500,000 views (taking three weeks less than the previous half million increment) – here’s a little breakdown on […]

    Pingback by Viewing Figures « Oracle Scratchpad — February 3, 2012 @ 9:32 am BST Feb 3,2012 | 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 )

Google+ photo

You are commenting using your Google+ 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.

Powered by