How to identify the OS from inside the Oracel DB

AskTom “How to identify the OS from the database”

[quote]
ops$tkyte-ORA10G> select dbms_utility.port_string from dual;

PORT_STRING
——————————————————————————-
Linuxi386/Linux-2.0.34-8.1.0

Solaris:
SunOS aria-dev 5.7 Generic_106541-20 sun4u sparc SUNW,Ultra-4

ops$tkyte@ORA817DEV> select dbms_utility.port_string from dual;

PORT_STRING
——————————————————————————-
SVR4-be-8.1.0
[/quote]

What a quite weird package/field name for the OS identification purpose. (but it works.)

Similar Posts:

Post a Comment

Your email is never published nor shared.