Parameter : forking more parallel processes

[madhuca-]

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

[Dennis Handly]

>How to find does this model supports PARALLEL_THREADS_PER_CPU

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

[madhuca-]

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

[Dennis Handly]

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