How to Calculate the Number of Processes for Oracle Database Release 11g

The number of user processes that can simultaneously connect to the Oracle database is limited by the PROCESSES initialization parameter of the Oracle database instance. By default, each Oracle Hyperion Financial Management application process requires a minimum of 200 database connections for a single server environment. When more than one Financial Management server has been configured for an environment, an additional pool is required for Cluster Controller connections to ensure application integrity. The Cluster Controller Pool is equal to the Application pool, therefore 400 connections per application process must be accounted for by the DBA.

Note:

The total number of servers in a cluster, and the total number of applications, affect the number of required database connections.

This example illustrates how to calculate the number of processes that connect to the Oracle database. Suppose a single Financial Management application server has two applications. The default Financial Management database connection pool setting is 200. The minimum number of Oracle database connections required for just Financial Management is 400. For additional safety, multiply this number by a factor of 1.1 to allow for ancillary connections and general usage of the database. Considering that the Oracle database also has some background processes, add 20 to the number to arrive at the value of PROCESSES. So, in this case, PROCESSES should be set to 460.

For single HFM applications server:

PROCESSES = (Financial Management connection pool setting) * (Number of Financial Management applications) *1.1 + 20.

Suppose a cluster of two Financial Management application servers has two applications on each server. The Financial Management database connection pool setting is 200 and the Cluster Controller pool would also be 200. The minimum number of Oracle database connections required for just Financial Management is now 1,600: (200+200)*2*2=1600.

For Multi-Server environment:

PROCESSES = (Financial Management connection pool setting + Financial Management Cluster Controller connection pool setting) * (Number of Financial Management applications) * (Number of Financial Management servers) *1.1 + 20.