Search This Blog

Total Pageviews

Tuesday, 28 April 2026

How to find cpu and memory information of oracle database server ?


 How to find cpu and memory information ?

set pagesize 200  lines 200
select STAT_NAME,dbms_xplan.FORMAT_SIZE(VALUE) as VALUE ,COMMENTS from v$osstat where 1=1
-- and stat_name IN ('NUM_CPUS','NUM_CPU_CORES','NUM_CPU_SOCKETS')
union
select STAT_NAME,dbms_xplan.FORMAT_SIZE(VALUE),COMMENTS from v$osstat 
--where stat_name IN ('PHYSICAL_MEMORY_BYTES')
;

No comments:

Oracle DBA

anuj blog Archive