Re: find out os from pl/sql

On Oct 18, 11:22 am, DA Morgan <damor..._at_psoug.org> wrote:
> Radoulov, Dimitre wrote:
> > "Loial" <a..._at_loial.co.uk> wrote in message
> >news:1161173211.505459.159290_at_e3g2000cwe.googlegroups.com...
> >> Is there any table I can query to find out the operating
> >> system(Linux/AIX etc) from pl/sql?
>
> > Check dbms_utility.port_string.
>
> > On RH:
>
> > SQL> select dbms_utility.port_string from dual;
>
> > PORT_STRING
> > ---------------------------------------------------------------------------­-----
> > Linuxi386/Linux-2.0.34-8.1.0
>
> > On Solaris:
>
> > SQL> select dbms_utility.port_string from dual;
>
> > PORT_STRING
> > ---------------------------------------------------------------------------­-----
> > SVR4-be-64bit-8.1.0
>
> > Regards
> > DimitreAlso:
> SELECT * FROM gv$version;
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -- Show quoted text -

Warning - depending on your Oracle version and platform neither command will provide the actual OS level

On AIX 5.2L running EE 9.2.0.6 RAC you get

Oracle Port String is IBM AIX64/RS6000 V4 - 8.1.0

While a UNIX uname command showd the OS is AIX 5.2 $ uname -svr
AIX 2 5 Release level appears before version in output when ever both are requested on AIX.

HTH -- Mark D Powell -- Received on Wed Oct 18 2006 - 11:56:07 CDT