on 09-07-2015 2:12 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.