Friday, January 25, 2013

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







'

No comments:

Post a Comment