System Administration
cancel
Showing results for 
Search instead for 
Did you mean: 

Parameter : forking more parallel processes

 
madhuca-
Occasional Advisor

Parameter : forking more parallel processes

  1. parallel_max_servers database parameter should be set to value 160 instead of 16.

Oracle default value for this parametere is CPU_COUNT x PARALLEL_THREADS_PER_CPU x (2 if PGA_AGGREGATE_TARGET > 0; otherwise 1) x 5.

In our case, CPU_COUNT is 8, PARALLEL_THREADS_PER_CPU is 2, PGA_AGGREGATE_TARGET > 0, hence we need to multiply by 2.

Hence value for this parameter should be, 8 X 2 X 2 X 5 = 160

 

--------------

 

OS version : HPUX 11i v3

model :BL 870c i2

server is configured as HPVM.

 

Can you please tell me if above oracle parameter change can be applied in HP UX.

When I google it,Oracle docs says it is OS dependant.

default value is 2.

Does HP UX supports those field.

what are the parameters in OS that are related to those Database parameters.

 

How to find does this model supports PARALLEL_THREADS_PER_CPU

 

 

 

3 REPLIES

Re: Parameter: forking more parallel processes

>How to find does this model supports PARALLEL_THREADS_PER_CPU

 

This is probably talking about hyperthreading.  I.e. PARALLEL_THREADS per core.

madhuca-
Occasional Advisor

Re: Parameter: forking more parallel processes

hi

 

 

but As i aware Hyper threading can't be set in HPVM.

 

is there any possible way to find what is the value of parellel threads for a cpu

Re: Parameter: forking more parallel processes

>As I aware Hyper threading can't be set in HPVM.

>is there any possible way to find what is the value of parallel threads for a core

 

Then the value is just one.