The Status After One Year

It is funny. I just realized that my website is over 1 year in existence. I started it as my personal XMLDB notepad on the 9th of April 2007. I wanted the site to be anonymous, but Doug blew the whistle on me, after we had met during Hotsos 2007 and somehow he found the content interesting and added this site to his blog roll. From that moment on I stopped playing with “the idea”; cleaned the website up and started blogging.

Most of my reasons to start this site stand still today:

  • I wanted an archive of some sort for my old articles on the AMIS Technology Blog site
  • I wanted a better insight in how much this XMLDB material / functionality was used worldwide. The AMIS site would cloud this issue to much because most of the articles there were Java/BPEL/SOA/Oracle related.
  • Somehow, I never can my find my tests, sql scripts etc. So therefore the “notepad” function.
  • I wanted to be able to write about stuff that inspired me and/or was open for a rant :-)

Looking back after 1 year, my hobby got a little out of hand (and indirectly contributed also to my Oracle ACE award). I am a little bit skeptical about Dan Norris article “You want to be an Oracle ACE?“. This skepticism is mostly driven by the verb “want“. I never “wanted” it, it just came over me, not realizing that all this fun stuff I was doing somehow contributed to the XMLDB community. If I would have “wanted it”, it would have been costing me to much energy and I would never have been able to keep it up.

Anyhow…

The Numbers

Probably the most interesting part is what are the most read posts on this website? Silly enough, one of the most read one is “SQL*Plus Command Line Options”. A post were I only printed the output while making a typo. Some of the figures indicated that XMLDB posts are gaining ground.

Most read posts

01) Solving VMware network problems on Linux
02) Oracle 11g – SQL*Plus Command Line Options
03) Oracle 11g – XMLType Storage Options
04) Windows Powerfull “SC” command – Handling Windows Services The Proper Way
05) HOWTO: Create XMLType Table for Binary XML
06) APEX installation via the Oracle Protocol Server
07) Oracle 11g – How to enable native WSDL services
08) Reclaim virtual redo disk space; VMware
09) Oracle 11g Security – XMLDB is here to stay
10) Mastering XML DB – COUNT and SUM
11) Oracle 11g – XMLIndex (part 1)
12) About Moving, DeDuplication, SecureFile
13) Registering non-default XMLDB HTTP/WebDAV and FTP ports
14) Small introduction to SQL*Net debugging
15) HOWTO: Enable the Protocol Server (Listener)

Top search keywords

01) cid adware
02) sqlplus command line
03) ora-24247
04) dizwell
05) sc command
06) ora-24247: network access denied by access control list (acl)
07) xmlsequence
08) sqlplus command line options
09) oracle xmlexists example
10) oracle 10.2.0.4

The “cid adware” keyword is probably found via a post were I described my troubles removing this trojan and apparently more and more people are using Oracle 11gR1 and encounter “ORA-24247″ errors / problems with the TCP packages combined with the increased security settings in the new database 11g release.

The totals


Click picture to enlarge

  • 31,551 Visits
  • 24,980 Absolute Unique Visitors
  • 46,612 Pageviews
  • 1.48 Average Pageviews
  • 00:01:16 Time on Site
  • 80.34% Bounce Rate
  • 79.22% New Visits

Geographic locations


Click picture to enlarge

Hmmm. So in all. Thanks, I feel honored.

8-)

More details here: Google Analytics 2007, 2008