Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Wednesday, July 14, 2010

dbms_utility.port_string

While going through a trace file I came across this SQL:

SELECT DBMS_UTILITY.PORT_STRING FROM DUAL;

Dbms_utility.port_string allows to find out what hardware and OS an Oracle instance runs on:

SQL> SELECT DBMS_UTILITY.PORT_STRING FROM DUAL

PORT_STRING
--------------------------------------------------------------------------------
SVR4-be-64bit-8.1.0

This was run on a Solaris box which has Solaris 10 64-bit OS with 64-bit SPARC processors.

No comments: