Hi Guy's,
Pls check this query to find the Database Server CPU's.
SQL> set pagesize 299
set lines 299
select STAT_NAME,to_char(VALUE) as VALUE ,COMMENTS from v$osstat where stat_name IN ('NUM_CPUS','NUM_CPU_CORES','NUM_CPU_SOCKETS' union
select STAT_NAME,VALUE/1024/1024/1024 || ' GB' ,COMMENTS from v$osstat where stat_name
IN ('PHYSICAL_MEMORY_BYTES') ;
STAT_NAME VALUE COMMENTS
------------------------------------------------------------------------------------------------------------------------------
NUM_CPUS 24 Number of active CPUs
NUM_CPU_CORES 12 Number of CPU cores
NUM_CPU_SOCKETS 2 Number of physical CPU sockets
PHYSICAL_MEMORY_BYTES 95.952686309814453125 GB Physical memory size in bytes
Happy Learning..
