I'm quite confused how many CPU used by our Prod database.
From AWR:
CPUs = 256
Cores = 32
Sockets = 2
Q1. Does it mean our physical server has 2 sockets and each socket has 16 cores and each core has 8 CPUs?
From OEM:
Core count = 8
Q2. Does it mean the database used 64 CPUs only(64/256)?
Checking CPU Parameter:
SYS@PROD> show parameter cpu
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cpu_count integer 8
parallel_threads_per_cpu integer 2
resource_manager_cpu_allocation integer 256
Q3. Can someone interpret the parameter comparing to the AWR and OEM?
Thank you..