Setting for oc4j-ra.xml

Oracle recommends to modify the container settings in oc4j-ra.xml. By doing so, it increases the performance of the SOA server.

Steps:
1) Goto the location SOA_HOME/j2ee/oc4j_soa/application-deployments/default/DbAdapter

2) Open the file oc4j-ra.xml

Default Value:
<connection-pooling use="none">
</connection-pooling>

New Value:
<connection-pooling use="private">
<property name="waitTimeout" value="300"/>
<property name="scheme" value="fixed_wait"/>
<property name="maxConnections" value="100"/>
<property name="minConnections" value="0"/>
</connection-pooling>

3) Similarly, open the file oc4j-ra.xml present under location:
SOA_HOME/j2ee/oc4j_soa/application-deployments/default/AqAdapter

4) Change the default value to the New value as shown above for DB Adapter.

5) Bounce the SOA Server.

Keep Learning with me...