OS Version Information

To obtain the hardware and OS version of your db server:

select dbms_utility.port_string from dual;


PORT_STRING
--------------------------------------------------------------
IBM AIX64/RS6000 V4 - 8.1.0


Slightly different information is returned by using:

SELECT RTRIM (

          SUBSTR (REPLACE (banner, 'TNS for ', ''),

                  1,

                  INSTR (REPLACE (banner, 'TNS for ', ''), ':') - 1))

          OS

  FROM v$version

 WHERE banner LIKE 'TNS for %';

Which displays:

OS
---------------------------------
IBM/AIX RISC System/6000

'