Oracle APEX Architecture Free Tutorial

This free tutorial explains APEX architecture, i.e. how the HTTP request/response cycle works, how an APEX application works (prerequesite knowledge), then introduces the options for an HTTP listening service: the embedded PL/SQL gateway, the Apache mod_plsql module, and the APEX listener deployed to either a Glassfish or a WebLogic container.

We summarize with benefits and recommendations for the various listener options.

Audience:  Oracle DBA’s, Internet Architects, System Admins, APEX Developers, anyone interested in learning how APEX works.

Presenter: John Watson, Oracle Certified Master and SkillBuilders’ Director of Oracle Database Services.

Moderator: Dave Anderson, SkillBuilders President and Oracle DBA

his free tutorial is segmented into the following modules:

  1. Introduction to John Watson, SkillBuilders Director of Oracle Database Services (1:59)
  2. Tutorial Agenda (2:35)
  3. Understanding the HTTP Request / Response Cycle (6:56)
  4. How an APEX Application Really Works (A Bit of Architecture) (12:21)
  5. Listener Options Part 1: Embedded PL/SQL Gateway & Apache (5:26)
  6. Listener Options Part 2: The Oracle APEX Listener (9:18)
  7. Recommendations and Next Steps (1:27) (click on video below)

Date: Jul 25, 2013

NOTE: Some corporate firewalls will not allow videos hosted by YouTube.


Recommendations and Next Steps

Oracle APEX Architecture and Listener Options 


Session 7 – SkillBuilders Recommendation, Next Steps


>> John:  Our recommendation? Definitely the APEX Listener. Why? Because it’s now Oracle’s recommendation. We believe that latest releases are now stable. It can support all the releases of the latest APEX. The future development path is certainly clear. 


Where to deploy it? I’m going to promote Glassfish because it’s license-free and Oracle stated it will be fully supported for the foreseeable future. But if you have a WebLogic license, sure by all means, deploy it through that. 




So what do you need to do next? You need to start assessing your APEX environments. Your current listening architecture, will it perform? Will it scale? Is it secure? Do your programmers need access to new facilities, RESTful services and so on? If they need the new facilities, you’ve got to really move to the APEX Listener. If they don’t, okay. You can delay. 




Definitely consider security audits. There are known issues with APEX applications. But there are solutions to all of them and the Glassfish APEX Listener part of the architecture should be totally secure. 


That pretty much means I’ve now run out of time.


Copyright 2017

Free Online Registration Required

The tutorial session you want to view requires your registering with us.

It’s fast and easy, and totally FREE.

And best of all, once you are registered, you’ll also have access to all the other 100’s of FREE Video Tutorials we offer!