Oracle Scratchpad

September 7, 2008

Page hits

Filed under: Site History — Jonathan Lewis @ 8:12 am BST Sep 7,2008

Another landmark – this morning the blog counter reached 750,000. It’s taken a little longer to get the third 250,000 than it did the second – but given how little I’ve written over the last few months it’s still a pleasant surprise.

WordPress supples some interesting stats, so I’ve copied up the top three entries for populare posts. [Edited: I did have an icon to the right that I though would let you see the stats for the post – but you have to log in as me to see them. The point of putting the icon there was to show that these searches show a fairly uniform pattern of arrival, rather than occasional peaks]

Cartesian Merge Join 10,718
Bind Variables 8,660
dbms_xplan in 10g 6,562

There’s also a section in the statistics about search times – unsurprisingly searches for my name, or the blog name feature quite highly, but the three commonest search terms are quite interesting:

ora-01722 1,418
oracle not in 1,231
merge join cartesian 1,162

All three of these look like search terms that are likely to have come from end-users who have been surprised by changes in execution plans after an upgrade to 10g.


  1. Congrats :)

    Comment by Amardeep Sidhu — September 7, 2008 @ 5:30 pm BST Sep 7,2008

  2. I’m running for the 10.000 at the end of the year!

    Not bad for a blog on music written in Italian. ^_^

    Comment by lascoltodelvenerdi — September 9, 2008 @ 7:52 am BST Sep 9,2008

  3. […] Filed under: Uncategorized — Jonathan Lewis @ 7:36 am UTC Oct 2,2008 I posted a summary of page hits a little while ago when the WordPress statistics hit 750,000 page views, and commented at the time […]

    Pingback by Upgrades « Oracle Scratchpad — October 2, 2008 @ 7:37 am BST Oct 2,2008

RSS feed for comments on this post.

Powered by