Oracle Setup For Morgan's Library Demos based on UW Class Curriculum

Oracle Host Environment Version 11.2.0.3

General Information
The entries on this page demonstrate ways, from within the Oracle database, to access information about the host hardware and operating system.
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';
Operating System Endian Value	SELECT dbms_utility.get_endianness FROM dual;
Operating System Environment Variables	set serveroutput on DECLARE RetVal VARCHAR2(100); BEGIN dbms_system.get_env('ORACLE_SID', RetVal); dbms_output.put_line(RetVal); END; / DECLARE RetVal VARCHAR2(100); BEGIN dbms_system.get_env('ORACLE_HOME', RetVal); dbms_output.put_line(RetVal); END; / DECLARE RetVal VARCHAR2(100); BEGIN dbms_system.get_env('TEMP', RetVal); dbms_output.put_line(RetVal); END; /