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.

Read: How To Find Execution History Of An sql_id
