1. Administrator's Guide
  2. Optimizing Performance
  3. Tuning Oracle 11g Databases for Financial Management
  4. Tuning Guidelines for Oracle 11g Databases
  5. PROCESSES

PROCESSES

PROCESSES specifies the maximum number of operating system user processes that can simultaneously connect to an Oracle database. Because Oracle Hyperion Financial Management only works with dedicated servers, each connection requires a process. Each Financial Management application requires a minimum of 200 (400 when in multi-server environments) database connections in addition to the number specified by the Financial Management database connection pool setting.

Suggested setting: Refer to How to Calculate the Number of Processes for Oracle Database Release 11g.