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

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
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

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

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