Hello everyone,
I’ve installed Oracle HTTP Server (OHS), Oracle Forms & Reports 11g, and Oracle APEX 20.1 on my Windows Server 2019 machine. Everything runs fine initially, but the system crashes or hangs whenever multiple users send requests at the same time.
System Specs:
* OS: Windows Server 2019
* CPU: 8 Cores @ 3GHz (can be increased if needed)
* RAM: 64 GB (can be reduced, but at least 16 GB is available)
I want Oracle components (OHS, Forms, Reports) to use as much CPU and memory as possible for best performance, since there are sufficient hardware resources available.
OHS (httpd.conf)
Can anyone suggest optimal performance settings for the following parameters to improve stability and multi-user handling?
# Worker MPM
<IfModule mpm_worker_module>
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
AcceptMutex fcntl
LockFile "${ORACLE_INSTANCE}/servers/${COMPONENT_NAME}/logs/http_lock"
</IfModule>
# WinNT MPM
<IfModule mpm_winnt_module>
ThreadsPerChild 150
MaxRequestsPerChild 0
</IfModule>
Should I increase these values to allow OHS to handle more concurrent connections and better utilize available CPU cores and memory?
Forms & Reports Configuration (rwserver.conf)
I’d also appreciate any advice on tuning the Reports Server configuration to avoid
max_connect errors or web server bridge failures when there are many simultaneous requests.
Here’s my current setup:
<server xmlns="http://xmlns.oracle.com/reports/server" version="11.1.2">
<cache class="oracle.reports.cache.RWCache">
<property name="cacheSize" value="50"/>
</cache>
<engine id="rwEng" class="oracle.reports.engine.EngineImpl" maxEngine="10" minEngine="10" engLife="50"/>
<engine id="rwURLEng" class="oracle.reports.urlengine.URLEngineImpl" maxEngine="1" minEngine="0" engLife="50"/>
<connection maxConnect="50" idleTimeOut="15"/>
<queue maxQueueSize="1000"/>
</server>
Should I increase maxEngine, maxConnect, or both to improve parallel processing and make full use of system resources?
Any recommended configurations or examples for high-performance setups would be very helpful.