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 the oracle database server.

How do I find CPU and memory information in Linux?

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');

How do I check what CPU I have?

Output from the above query.

Read: How To Find Execution History Of An sql_id