Hi,
Is there any view I can use to know the OS name on which the Oracle Server is running ?
RS
Printable View
Hi,
Is there any view I can use to know the OS name on which the Oracle Server is running ?
RS
type 'uname -a' on unix machines
select username, osuser
from v$session
where username is not null
or type: hostname
There's obviously some confusion as to what you are looking for. Could you elaborate?
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
v$session is as close as you can get, as far as I know.
Hi
Select host_name from v$instance;
Santosh
Hi
One More
Select * from v$version
Santosh
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