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 - 2025 psoug.org
-----