Hi all - I'm having an issue when running apex in a distributed architecture. If i install APEX locally on the same box as the database server. I get good performance, but when I run the APEX web portion from a separate web server the performance is appalling. It takes about 6 minutes for the initial login to comeback and similar response time using the basic widgets on the admin page.
The Web Server and Database server are separated by a Cisco firewall (FWSM module in 6500). I've already bumped up the "Shared_Servers" parameter to 20, with no effect.
Just wondering if there's something else i should be looking at.
Can you please describe what "when I run the APEX web portion from a separate web server" means? What is installed on the Web server? What are you using to connect from the separate Web server to the APEX engine in the Oracle database?