topic Re: Parameter: forking more parallel processes in Operating System - HP-UX

Parameter : forking more parallel processes

madhuca- — Mon, 07 Sep 2015 16:38:55 GMT

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

Dennis Handly — Mon, 07 Sep 2015 23:19:26 GMT

>How to find does this model supports PARALLEL_THREADS_PER_CPU

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

madhuca- — Tue, 08 Sep 2015 12:44:41 GMT

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

Dennis Handly — Tue, 08 Sep 2015 17:18:58 GMT

>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.