select * from V$OSSTAT where stat_name='NUM_CPUS';

select * from V$OSSTAT where stat_name='NUM_CPU_CORES';

select * from V$OSSTAT where stat_name='NUM_CPU_SOCKETS';