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


Some Definitions
– 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

set pages 1000 lines 220
col value for a20
col stat_name for a30
col comments for a60
from v$osstat where
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



Post a comment


acehints.com Copyright 2011-20 All Rights Reserved | Site Map | Contact | Disclaimer | Google