Who uses apex.oracle.com?

For those who don't know, Oracle hosts a demonstration version of Oracle Application Express at http://apex.oracle.com. Anyone on the planet can sign up for a workspace, and as long as you don't run a production or commercial Web site, don't do anything illegal and also understand that there is no Service Level Agreement, it's all yours to try out Oracle Application Express. The ultimate goal, though, is for anyone to try Application Express with without having to download, install, or configure anything. All you need is a modern Web browser. And trust me - no one from sales or marketing will call.

In late 2007, I became inspired and installed some Google Analytics JavaScript code in the Login Message and System Message areas of the Application Express instance (you access this from internal administration, Manage Service -> Messages). This tracks access to the Login page and almost all of the pages in Application Builder, SQL Workshop and Utilities. It does not track any information for user-created applications - only the development environment and the general APEX login page. And it's only used for general information and also to satisfy my curiosity.

If you've ever used Google Analytics before, you're already aware of the wealth of information that is recorded. So who uses apex.oracle.com? Looking at the number of visits broken down by country from December 1, 2007 through February 12, 2008:

• United States - 30%
• United Kingdom - 10.5%
• India - 10%
• Germany - 6%
• Netherlands - 3%

What I did find most surprising was that Japan was listed as #12, even though I know there has been reasonably good interest in Application Express in Japan, China and Korea since the days of HTML DB 1.5.

The top 25 are here:



I also found interesting the keywords people used on Google to navigate to apex.oracle.com. Four of the top ten are related to Denes Kubicek. Congratulations, Denis!



Please don't confuse these statistics with overall scalability of this instance or Application Express. I'm only presenting the Google Analytics visits. For the past week, on apex.oracle.com, there were:

• 1,637,781 page views
• 2,093 distinct applications used in the past week
  
• 2,947 distinct users authenticated in the past week
• 224 new workspaces approved
• 13,745 total workspaces

It's running on a Dell PowerEdge 1950 with 2 Dual Core Xeon processors. Average load on the database server hovers around 16%.



Update: In response to Denes' request for the top used applications, I've found the following in descending order of activity in the past week:

PROMED:         ProMED-mail Public Site
WORK:           OTN EXAMPLES
DKUBICEK:       My Demo Application
RTI:            OCU_BCK
ASKSTEVEN:      AskSteven
EBA:            Checklist Manager 1.0
EBA:            Online Store 1.0
DBTOOLS:        SQL Developer Exchange
OSC:            OnScreen
HENRY:          Avance Issue Tracker 1.0
ACES:           Oracle ACEs
MIKA:           MyFirehouse
PALGW:          Applicant Tracking System
EBA:            Asset Manager 1.0
EMAIL_HELPDESK: Email Helpdesk
JOEL2:          Workspace Purge

Granted, I did have to filter some stuff out, because Application Builder and SQL Workshop are always in the top 10. Also, there are some applications for SQL Developer and JDeveloper check-for-updates which are not really relevant to Denes' question.

I think Denes is really trying to rub it in. Note how the Workspace Purge application has generated much activity as people scramble to preserve their seldom-used workspaces.