cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle Processes and Sessions

liamclark1
Explorer
0 Kudos

Hi hopefully this is an easy question to answer

I have noticed that the parameters Processes and Sessions are set too low on our ECC6 system. However i am not sure by how much.

I know the values should be worked out by the following

PROCESSES

(#ABAP work processes * 2) +

(#J2EE server processes * <max-connections> ) +

PARALLEL_MAX_SERVERS + 40

SESSIONS = 2 * PROCESSES

Our system is ABAP only so i dont need to count the J2ee section. However for the ABAP work processes, what i am confused about is if this should be just the central instance's work processes or should include the additional work processes from the application server connected to it?

e.g. i have a central instance with the DB on which has 21 WPs and an app server connected to it with 14 WPs. So should the first calculation be (21*2) or ((21+14)*2)

Can someone confirm?

Regards

Accepted Solutions (0)

Answers (1)

Answers (1)

stefan_koehler
Active Contributor
0 Kudos

Hi Liam,

> what i am confused about is if this should be just the central instance's work processes or should include the additional work processes from the application server connected to it?

All work processes in your SAP system need to be counted as a SAP work process and an Oracle shadow process is a one-to-one relationship (disregarding PX right now). However one process can also open multiple sessions (and this is the reason why sessions need to be twice processes).

> e.g. i have a central instance with the DB on which has 21 WPs and an app server connected to it with 14 WPs. So should the first calculation be (21*2) or ((21+14)*2)

processes = (21 + 14) x 2 = 70

sessions = 70 x 2 = 140

Regards

Stefan

liamclark1
Explorer
0 Kudos

thanks for the quick response, though I would need to also factor the "+ PARALLEL_MAX_SERVERS + 40" into the equation too. so it seems like our parameters are much lower than necessary.

especially on our live system which has 3 application servers attached to it.

so ((Central +APP1 +APP2 +APP3) x2) +PARALLEL_MAX_SERVERS +40

Regards,

Liam

stefan_koehler
Active Contributor
0 Kudos

Hi Liam,

> ((Central +APP1 +APP2 +APP3) x2) +PARALLEL_MAX_SERVERS +40

Exactly, this is the formula for the parameter processes.

> so it seems like our parameters are much lower than necessary.

Your current settings maybe sufficient, if you do not get Oracle errors like "ORA-00020", but maybe not anymore if SAP uses different Oracle features. The mentioned formula takes all of these into account.

Regards

Stefan