CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle Host Environment

Version 11.1
 
Number of CPUs col value format 99999

SELECT value
FROM gv$osstat
WHERE stat_name = 'NUM_CPUS';
Amount of Physical Memory col value format 999999999999

SELECT value
FROM gv$osstat
WHERE stat_name = 'PHYSICAL_MEMORY_BYTES';
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [135 users online]    © 2010 psoug.org