Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX Listener and Caching

915154Nov 29 2012 — edited Dec 1 2012
I'm having a discussion with a colleague (ok an argument) so I have a basic question about the APEX Listener and caching for the forum. Our current environment is:

OHS 11g (with the weblogic plug-in) --> WebLogic 11g (with APEX Listener deployed) --> Oracle 11g (APEX packages deployed).

The user goes to the APEX URL via the browser, it's forwarded by the weblogic plug-in to the APEX Listener, which in turn forwards it to the DB. The APEX application processes the request and does its thing to generate an HTML page and returns it eventually to the browser. On and on, etc.

My question is this. Does the APEX listener in this type of scenario send any application specific sql or pl/sql calls to the Database (other than dealing with the connection pool) for processing by the application or does it just act as a proxy and forward HTML to the database for processing by the DB/APEX application which does all the pl/sql calls?

My colleague wants to turn on caching on the APEX Listener but I'm thinking this won't help because I assumed that the listener doesn't generate any application specific SQL or PL/SQL calls to be cached.

Thanks,

rowdycholin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 29 2012
Added on Nov 29 2012
3 comments
328 views