ODA: Understanding relationship between Core counts and Sockets and CPUs
Hi MOSC,
For our ODA X5-2, we'd like to understand the relationship between Core counts and Sockets and CPUs.
In setting up the db at oakcli create database, we chose option "3" for Database Class;
3 => odb-02 ( 2 cores , 16 GB memory)
-------------------------------------------------------------------------------------
How does the above choice relate to result of the following 2 queries;
-------------------------------------------------------------------------------------
1) SYS prd11g05 SQL> show parameter cpu_count;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cpu_count integer 4
2) select
(select max(value) from dba_hist_osstat
where stat_name = 'NUM_CPUS') c1,
(select max(value) from dba_hist_osstat
where stat_name = 'NUM_CPU_CORES') c2,
(select max(value) from dba_hist_osstat