OS name

[rsonnathi]

Hi,

Is there any view I can use to know the OS name on which the Oracle Server is running ?

RS

[pwoneill]

type 'uname -a' on unix machines

[marist89]

select username, osuser
from v$session
where username is not null

[Halo]

or type: hostname

[marist89]

There's obviously some confusion as to what you are looking for. Could you elaborate?

[rsonnathi]

Jeff Hunter ,

What I mean is If I want to find OS name programatic way, is there any dictionary view to find that info.I have window 4.0.Can I get that info ?

The following query gives domain name but not the OS name

select username, osuser
from v$session
where username is not null

Thanks.

RS

[marist89]

v$session is as close as you can get, as far as I know.

[sanrak]

Hi

Select host_name from v$instance;


Santosh

[sanrak]

Hi

One More

Select * from v$version


Santosh

[denevge]

Maybe you can do somthing with :

select banner from v$version
where banner like 'TNS%' ;

on NT i get : TNS for 32-bit Windows: Version 2.3.4.0.0 - Production
on AIX i get : TNS for IBM/AIX RISC System/6000: Version 2.3.4.0.0 - Production

Regards
Gert