DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: OS name

  1. #1
    Join Date
    Dec 2000
    Posts
    32
    Hi,

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

    RS

  2. #2
    Join Date
    Jun 2000
    Posts
    417
    type 'uname -a' on unix machines

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    select username, osuser
    from v$session
    where username is not null
    Jeff Hunter

  4. #4
    Join Date
    Apr 2000
    Location
    Baltimore, MD
    Posts
    759
    or type: hostname

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

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

  6. #6
    Join Date
    Dec 2000
    Posts
    32
    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



  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    v$session is as close as you can get, as far as I know.
    Jeff Hunter

  8. #8
    Join Date
    Nov 2000
    Posts
    25
    Hi

    Select host_name from v$instance;


    Santosh

  9. #9
    Join Date
    Nov 2000
    Posts
    25
    Hi

    One More

    Select * from v$version


    Santosh

  10. #10
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width