How To Find CPU And Memory Information Of Oracle Database Server

Hello friends, In this article we are going to find cpu and memory information of oracle database server.

The below script will help us to get CPU, memory and core, socket information of an Oracle database server from SQL prompt.

set pagesize 299
set lines 299

SQL> 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,VALUE/1024/1024/1024 || ' GB' ,COMMENTS from v$osstat where stat_name IN ('PHYSICAL_MEMORY_BYTES');

Output from above query.