Skip to Content

Note: 1431798 has proved relevant in improving performance several times.

Each SAP Sourcing uses a number of Database connections which increases with each instance added as the sourcing application seeks to allocate and hold Database connections. 

The standard values that affect this are as follows.

Parameter Default value

Sessions

248

Processes

124

Max connections

90
PARALLEL_MAX_SERVERS 109

Within Note 1431798 it mentions the following formulas for the Database.

SESSIONS =  2 * PROCESSES

PROCESSES =  #J2EE server processes = <max-connections> + PARALLEL_MAX_SERVERS + 40

Parameter New Values

Sessions

420

Processes

210
Max connections 90
PARALLEL_MAX_SERVERS 109

The required increases are highlighted in BOLD for the Session and Processes settings.

This should prevent certain bottlenecks in database connections.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply