11g (single instance) on AIX 6.1 : parallelism
In 11g (single instance) on AIX 6.1 , in order to implement parallelism how to choose :
- DOP (Degree Of Parallelism) : AUTO ? PARALLEL_DEGREE_POLICY=AUTO is enough ? recommended ?
According to http://docs.oracle.com/cd/E11882_01/server.112/e25523/parallel002.htm
DOP = PARALLEL_THREADS_PER_CPU x CPU_COUNT (single instance)
but what about cores per CPU ?
How to know PARALLEL_THREADS_PER_CPU ?
How to choose PARALLEL_MAX_SERVERS ?
Other important parameters to implement parallelism ?
Thanks.
GD.