PSOUG Home Code Snippets Oracle Lookup Oracle Reference Oracle Error Codes Oracle Functions PSOUG Forum


 
 Search the Reference Library pages:  

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 |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us    © 2003 - 2024 psoug.org
-----