Parameter parallel_threads_per_cpu

Hi,

these are the characteristics of the CPU of the server (AIX 6.1) that hosts the datawarehouse database:

oracle@dwhbi-11G-EDWHPROD (/home/oracle)# lsdev | grep -i proc

proc0        Available 00-00       Processor

proc4        Available 00-04       Processor

proc8        Available 00-08       Processor

proc12      Available 00-12       Processor

oracle@dwhbi-11G-EDWHPROD (/home/oracle)# lsattr -El proc0

frequency   3000000000         Processor Speed               False

smt_enabled true                     Processor SMT enabled     False

smt_threads 4                          Processor SMT threads     False

state       enable                       Processor state                  False

type        PowerPC_POWER7  Processor type                   False

Every CPUs has 4 threads. 

These are the value of the database parameters parallel_threads_per_cpu and cpu_count:

SQL> show parameter cpu