How to check CPU and memory info in Oracle from V$OSSTAT

V$OSSTAT reports the operating-system facts as Oracle sees them: NUM_CPUS (logical CPUs including hyperthreads), NUM_CPU_CORES, NUM_CPU_SOCKETS, and PHYSICAL_MEMORY_BYTES. Handy for capacity planning and for confirming licensing math (Oracle licenses on cores, not threads).

SET PAGESIZE 200 LINES 200
COL name      FORMAT a21
COL stat_name FORMAT a25
COL value     FORMAT a20
COL comments  FORMAT a56

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,
       ROUND(value / 1024 / 1024 / 1024, 2) || ' GB' AS value,
       comments
FROM   v$osstat
WHERE  stat_name = 'PHYSICAL_MEMORY_BYTES';