Oracle is not using all the CPUs (Core) of servers.
- two quadcore processors with a total of 8
core
- SQL> show parameter cpu
NAME
TYPE VALUE
------------------------------------
----------- ------------------------------
cpu_count
integer 8
We identified the problems when running
jobs, when we create a index with and without paralell. We found that
4 cpus always have high cpu waite.
Here.
CPU0 : 18.4% us,
1.9% sy, 0.0% ni, 41.7% id, 35.9% wa, 0.0% hi, 1.9% si
CPU1 :
0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0% si
CPU2
: 10.8% us, 4.9% sy, 0.0% ni, 4.9% id, 77.5% wa, 0.0% hi, 2.0%
si
CPU3 : 5.8% us, 2.9% sy, 0.0% ni, 1.0% id, 90.3% wa,
0.0% hi, 0.0% si
CPU4 : 5.8% us, 1.9% sy, 0.0% ni, 1.9%
id, 88.3% wa, 0.0% hi, 1.9% si
CPU5 : 0.0% us, 0.0% sy, 0.0%
ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0% si
CPU6 : 0.0% us, 0.0%
sy, 0.0% ni, 99.0% id, 1.0% wa, 0.0% hi, 0.0% si