$ lscpu |grep "^CPU(s)\|[Cc]ore\|Socket(s)"
CPU(s):                24
Thread(s) per core:    2
Core(s) per socket:    6
Socket(s):             2
$ sqlplus -s "/ as sysdba" <<< "select stat_name, value from v\$osstat where stat_name in ('NUM_CPUS','NUM_CPU_CORES','NUM_CPU_SOCKETS');"

STAT_NAME                                                             VALUE
---------------------------------------------------------------- ----------
NUM_CPUS                                                                 24
NUM_CPU_CORES                                                            12
NUM_CPU_SOCKETS                                                           2