A Frequently Asked Questions

A.1 Increasing the Connection Pool Size

Perform the following steps to increase the connection pool size:

1. Log into the WebLogic console.

2. Navigate to Services > Data Sources.

3. Click the data source for which you want to increase the connection pool size.

4. Navigate to the Connection Pool tab.

5. Specify the number of connections in the attribute Maximum Capacity. Oracle recommends that you set this to at least 100.

6. For details on this configuration, click More Info… right across this attribute.

A.2 Application Running Out of Connections

• This issue can be resolved by increasing the number of connections as mentioned in Section A.1.

• Better performance can be achieved by modifying the following attributes:

  • Initial Capacity

  • Maximum Capacity: Maximum number of connections depends on the number of users. For example, if there are10 users the suggested number of connections should always be multiplied by 10 (that is, 10 *10 = 100).

  • Capacity Increment: This value depends upon the multiplication factor being used to calculate maximum capacity (as per above scenario, it is 10).

For more information, see Tuning Data Source Connection Pools in Oracle® Fusion Middleware Configuring and Managing JDBC Data Sources for Oracle WebLogic Server.

To optimize performance, Oracle recommends that you update the heap memory and fetch size of the WebLogic server:

• Exadata

  Heap memory -15GB, Fetch Size- 150

• Non Exadata

  Heap memory - 8 GB, Fetch Size - 100

A.3 Parallelization

For details on parallelization, see Appendix A, Parallelization in the Oracle Healthcare Translational Research Installation Guide Release 3.2 available at

http://docs.oracle.com/health-sciences/translational-research-32/HTRIG/dop.htm#CHDCHFIF