Tuning Oracle Reports performance - FMW 12.2

Symptoms :

Oracle Reports taking time to load 

Oracle  report Engine crashing

Solution

1. Take a backup and edit the rwserver.conf file from: 

DOMAIN_HOME/config/fmwconfig/servers/WLS_REPORTS/applications/reports_12.2.1/configuration 

2. Change  from

<property name=”cacheSize” value=”50″/> 

To 

<property name=”cacheSize” value=999″/> 

3. Change from

maxEngine=”1″ minEngine=”0″ engLife=”50″ maxIdle=”30″> 

To 

” initEngine=”2″ maxEngine=”4″ minEngine=”2″ engLife=”5″ maxIdle=”30″ callbackTimeOut=”180000″ jvmOptions=”-Xmx2048M -Xms1024M”> 

4. <connection maxConnect=”200″ idleTimeOut=”120″> 

Save, restart Report server & WLS_REPORTS.