Skip to Content
avatar image
Former Member

How to calculate the number of PROCESSes required in ora 10.2.0.2 system

Dear Gurus

I have 2 questions.

Q1. I am little bit confused over the parameters below

*PARALLEL_MAX_SERVERS= #DB-CPU-Cores * 10*

Where can i find the DB-CPU-Cores value

what is meant by CPU_COUNT=2

at os level the command prtconf gives:

in development system:

Processor Type: PowerPC_POWER6

Number Of Processors: 1

Processor Clock Speed: 4704 MHz

CPU Type: 64-bit

Kernel Type: 64-bit

in production system:

Processor Type: PowerPC_POWER6

Number Of Processors: 2

Processor Clock Speed: 4704 MHz

CPU Type: 64-bit

Kernel Type: 64-bit

Q2.

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

Regarding number of J2EE server process, can i get the information from Visual Admin (ex; my production has 2 J2EE server processes).

max-connections: is this the value about the max number of concurrent users who logged in at a time.

PARALLEL_MAX_SERVERS =?

let me know in detail

Thanks in advance

Balaji nampally

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Sep 03, 2008 at 07:21 AM

    Q1. I am little bit confused over the parameters below

    *PARALLEL_MAX_SERVERS= #DB-CPU-Cores * 10*

    Where can i find the DB-CPU-Cores value

    Nowadays CPUs may have more than one core, means, there is more than one processing unit on a die (http://en.wikipedia.org/wiki/Multi-core_(computing)).

    in development system:

    Number Of Processors: 1

    in production system:

    Number Of Processors: 2

    What´s the output of

    lscfg | grep proc

    > Regarding number of J2EE server process, can i get the information from Visual Admin (ex; my production has 2 J2EE server processes).

    Yes. Two server processes + one dispatcher + an SDM means 4 total processes.

    max-connections: is this the value about the max number of concurrent users who logged in at a time.

    Are you now talking about a database parameter or about the J2EE engine parameters? A J2EE engine uses pooled connections, means, multiple applications use the same connections. The number can be configured using configtool (or visual admin).

    Markus

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thaks Markus

      For production systems

      BI

      1. lscfg | grep proc

      + proc0

      + proc2

      + proc4

      #

      EP

      1. lscfg | grep proc

      + proc0

      + proc2

      #

      max-connections: is this the value about the max number of concurrent users who logged in at a time.

      Are you now talking about a database parameter or about the J2EE engine parameters? A J2EE engine uses pooled connections, means, multiple applications use the same connections. The number can be configured using configtool (or visual admin).

      actually i need to configure the number of processes for my BI 7.0 system and EP 7.0 systems..

      for this where can i get the detailed information.

      Thanks Markus