SQL Query to Get Oracle Database Server CPU, CPU CORE, CPU Sockets and Physical Memory

advertisements

_____________________________________________________________________________________________________________________

Some Definitions 

CPU 

– Number of Processing Units in the server which is a main component of a server. 

CPU Core 

– Brain of the CPU. Each core performs operations separately from others. Multiple cores works to together to perform a parallel operation. 

CPU Socket 

– A CPU socket or CPU slot contains one or more mechanical components providing mechanical and electrical connections between a microprocessor and a printed circuit board. 

Physical Memory 

–  random-access memory (RAM)) is a form of very fast, but volatile data storage

advertisements

 

set pages 1000 lines 220
col value for a20
col stat_name for a30
col comments for a60
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) || ' GB' ,COMMENTS
from v$osstat where stat_name IN ('PHYSICAL_MEMORY_BYTES');

STAT_NAME                      VALUE                COMMENTS
------------------------------ -------------------- ------------------------------
NUM_CPUS                       88                   Number of active CPUs
NUM_CPU_CORES                  44                   Number of CPU cores
NUM_CPU_SOCKETS                2                    Number of physical CPU sockets
PHYSICAL_MEMORY_BYTES          1007 GB              Physical memory size in bytes

_____________________________________________________________________________________________________________________

Website Stats