Recommended Oracle init parameters

Edit online

The Oracle init parameters have recommended settings for Sterling B2B Integrator performance with an Oracle database.

Parameter Recommended value
processes Must be greater than the number of connections that are required by Sterling B2B Integrator (sum of transactional or local and NoTrans pools in the jdbc.properties file), and operational management tools.
  • sga_max_size
  • sga_target
  • pga_aggregate_target
 1 GB to n GB, depending on the amount of physical memory on your database server. If the server is running only this database, up to 80% of physical memory.

To size SGA (Shared Global Area) pools automatically, see SGA pool sizing.

timed_statistics True
optimizer_mode All_rows
open_cursors 2000 or higher if prepared statement caching is to be used.