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')
;
Search This Blog
Total Pageviews
Tuesday, 28 April 2026
How to find cpu and memory information of oracle database server ?
Subscribe to:
Post Comments (Atom)
Oracle DBA
anuj blog Archive
- ► 2011 (362)

No comments:
Post a Comment