How Identifying 32 or 64 bit mode ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How Identifying 32 or 64 bit mode ?

  1. #1
    Join Date
    Jan 2001
    Posts
    2

    Question

    How may I identify if an Oracle installation was made using 32 or 64 bits distribution ?
    I'd like to identify it using only Oracle commands, not operating system commands.

    Thanks in advance.

  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    I think this question was posted here a few weeks back...try connecting thru SQL/Plus; if it was 64-bit, it will display it in product version info; if it is 32-bit, it won't say anything about 32-bit or 64-bit.

    - Rajeev

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    select * from v$version will show you if Oracle is 64 bit or 32...

    Now can anyone tell me how to check if SOlaris version running in my machine is 32 or 64 bits? :D

  4. #4
    Join Date
    Jan 2001
    Posts
    2

    Red face

    The v$version doesn't show 32 or 64 bit mode, at least when selecting its contents
    from a 32 bit installation.

    Is there another way besides SqlPlus ?

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    [QUOTE][i]Originally posted by pando [/i]
    [B]Now can anyone tell me how to check if SOlaris version running in my machine is 32 or 64 bits? :D [/B][/QUOTE]
    isainfo -v or isainfo -b
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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