This content has been marked as final. Show 10 replies
The problem is the EPG as now everything comes from the database (images, files etc). When you ran Apache, it didn't need to go to the database for everything in /i/.
Especially when you are in a multi-user environment it's not recommended to go with the EPG.
So my recommendation is to install the APEX Listener which you find here: http://www.oracle.com/technetwork/developer-tools/apex-listener/overview/apex-listener-155260.html
From APEX 4.0 onwards you have 3 choices for the webserver: EPG, Apache and APEX Listener.
I don't use Windows myself, but I believe Apache 2 runs fine on Windows Server 2008, so alternatively you can download that, install mod/plsql and go with that.
Hope that helps,
I don't use Windows myself, but I believe Apache 2 runs fine on Windows Server 2008, so alternatively you can download that, install mod/plsql and go with that.Or, since you are running on Windows, you can check out the free Thoth Gateway, a mod_plsql replacement for IIS:
Thanks for taking the time to answer my question. So you are saying the listener which is my third choice should eliminate this issue. I know oracle have three choices for the web server but I'm only familiar with the two mentioned above, the APEX installation document provide information about the listener but haven't gone that path yet. The apache 2 only comes packaged for 32 bit systems (last I checked 2.16), and they don't have the 64bit version. I'm going to try the listener approach and see how it goes. Hopefully this will solve the issue with page loading slow. Should I uninstall the embedded PL/SQL or just continue with the listener install?
Thanks for your suggestions but I'm going to stick with the Oracle suggested methods for now. Hopefully some will work out for our environment.
SQL> show parameter shared_servers
NAME TYPE VALUE
shared_servers integer 1
We are still in testing environment (11g - APEX 4.1) and haven't released the new server yet (USED THE EPG SERVER) about 2 to 3 users. Our production still using the old server Oracle 10g - 3.0 APEX (No problem here we are using the APACHE SERVER)
Edited by: Mhnd on Sep 3, 2010 9:07 AM