Server Hardware configuration for APEX
cmovvaJul 23 2009 — edited Jul 23 2009How do I know/prove that for how many users the following hardware configuration can be supported!
It is intened to use the HTTP server and mod_plsql pluin of the Oracle Internet Application Server.
Here is the configuration.
Middle tier: Oracle Internet Application Server SE 10g(10.1.2.0.2), CPU-1, Cores - 1, RAM: 2GB expandable to 16GB
Data tier: Oracle Database Server SE 10g(10.2.0.4), CPU - 2, Cores - 1, RAM - 4GB expandable to 16GB
10 page views/user session for the duration of 10-15 min.
The question, for how many users the APEX application deployed on this configuration can support for a reasonable performance.Aslo, what is the perceived reasonable performance for APEX page views? Is it sec or milli secs of 250 or 500!
There is a perception/fear that if the Apex application deployed on an existing production database(intended to use existing database schemas) the performance of the database will be degraded as it needs to support APEX users possibly in few thousands(approx. 3000). How to prove that it will not be the case? or what changes required to be performed on the hardware interms of the CPU, RAM etc. provided all the best practices are followed in developing the APEX application.
Thanks in advance for the help.