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

[Former Member]

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

[markus_doehr2]

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

[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