Skip to Content
avatar image
Former Member

Oracle parameter: processes

Hi Guys,

There is a oracle parameter : processes and refer the sapnote : 1431798, the following is the suggested formula:

#ABAP
work processes * 2 + #J2EE
server processes * <max-connections>
+ PARALLEL_MAX_SERVERS
+ 40

If I have a total of 17 ABAP processes..

May I know where to check the J2EE server processes and also the max-connections ?

I tried the following with value I 'assumed' :

ABAP processes = 17

J2EE processes = I have only one server0, so is 1.

max-connections = as per what I saw in jdbc connection in visual administrator, it is 100.

PARALLEL_MAX_SERVERS = 40

So the total processes for this oracle parameter will be (17*2)+(1*100)+40+40 = 214.

Am I in the correct track ?

Best Regards,

Ken

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 03, 2013 at 04:31 PM

    Hello Ken,

    Yes, this seems fine. I will just recommend you to bump this a bit up to 250 or 300 to allow some future growing.

    Best regards,

    Thiago

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04, 2013 at 09:51 AM

    Am I in the correct track ?

    Absolutely.

    Regards

    RB

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 12, 2013 at 04:34 AM

    hi Ken,

    Please follow below SAP Notes and calculate the formulas as per instructions.

    For Oracle 11g.

    Note 1431800 is a Oracle 11.2.0: Central Technical Note

    11G: SAP Note 1431798 - Parameter recommendations for Oracle 11g

    For Oracle 10g.

    10G: SAP note Note 830576 - Parameter recommendations for Oracle 10g

    Regards,

    Add comment
    10|10000 characters needed characters exceeded