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