Tuesday, October 7, 2008

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.

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">

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"/>

3) Similarly, open the file oc4j-ra.xml present under location:

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

5) Bounce the SOA Server.

Keep Learning with me...


Mobile World said...
This comment has been removed by the author.
Mobile World said...

Abhishek, would you tell us what exactly are you doing by putting some new values in the connection pooling.
By the way what are the default values?