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
forums.oracle.com 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
oaktable.net 3,691 The Oak Table site. Most from the aggregator
jlcomp.demon.co.uk 3,235 My old web page. Most are from the front page
orana.info 2,330 Eddie Awad’s feed aggregator
dbaspot.com 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

3 Comments »

  1. Great job Jonathan!

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

    Sean.

    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

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 3,507 other followers