Check CPU and memory info of DB server from SQL commands

Check CPU and memory info of DB server from SQL commands

Check the CPU information

set pagesize 200
set lines 200
col name for a21
col stat_name for a25
col value for a10
col comments for a35
select STAT_NAME,to_char(VALUE) as VALUE ,COMMENTS from v$osstat where
stat_name IN ('NUM_CPUS','NUM_CPU_CORES','NUM_CPU_SOCKETS');

STAT_NAME                 VALUE      COMMENTS
------------------------- ---------- -----------------------------------
NUM_CPUS                  8          Number of active CPUs
NUM_CPU_CORES             4          Number of CPU cores
NUM_CPU_SOCKETS           1          Number of physical CPU sockets

Check the Physical memory info

set pagesize 200
set lines 200
col name for a21
col stat_name for a25
col "Value GB" for 9999.99
col comments for a30
select STAT_NAME,VALUE/1024/1024/1024 "Value GB",COMMENTS from
v$osstat where stat_name IN ('PHYSICAL_MEMORY_BYTES');

STAT_NAME                 Value GB COMMENTS
------------------------- -------- ------------------------------
PHYSICAL_MEMORY_BYTES        15.86 Physical memory size in bytes

Check free physical memory detail information

set pagesize 200
set lines 200
col name for a21
col stat_name for a25
col "Value GB" for 9999.99
col comments for a30
select STAT_NAME,VALUE/1024/1024/1024 "Value GB" ,COMMENTS from v$osstat where stat_name in ('FREE_MEMORY_BYTES');

STAT_NAME                 Value GB COMMENTS
------------------------- -------- ------------------------------
FREE_MEMORY_BYTES             7.78 Physical free memory in bytes

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.