Search

OakieTags

more tags

Who's online

There are currently 0 users and 23 guests online.

Recent comments

Affiliations

Home

Visitors etc.

Submitted by Jonathan Lewis on Tue, 2011-03-22 13:00

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