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

Thread: 32 bit or 64 bit

  1. #1
    Join Date
    May 2002
    Posts
    22

    32 bit or 64 bit

    Hi All

    How can I find the Oracle is 32 bit or 64 bit..?

    I run the query v$version in my database and result is

    select * from v$version

    BANNER
    ----------------------------------------
    Oracle8i Enterprise Edition Release 8.1.
    PL/SQL Release 8.1.7.0.0 - Production
    CORE 8.1.7.0.0 Production
    TNS for Solaris: Version 8.1.7.0.0 - Pro
    NLSRTL Version 3.4.1.0.0 - Production
    5 rows selected



    Please help me to find the oracle is 32 bit or 64 bit?

    Thanks
    Bala chander

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    It will say "64bit" Like this

    Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
    PL/SQL Release 8.1.7.4.0 - Production
    CORE 8.1.7.0.0 Production
    TNS for Solaris: Version 8.1.7.4.0 - Production
    NLSRTL Version 3.4.1.0.0 - Production
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #3
    Join Date
    May 2002
    Posts
    22
    In my database version, it is like "Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production".

    So can assume that, it is 32 bit version?

    Thanks
    J.Bala chander

  4. #4
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    'Ding Ding Ding' You are correct sir! Thanks for playing on DBA Support.com!! and have nice day
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  5. #5
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Originally posted by orakumar
    In my database version, it is like "Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production".

    So can assume that, it is 32 bit version?

    Thanks
    J.Bala chander
    Will maybe there is an Oracle8i release that is for 16-bit.

  6. #6
    Join Date
    Jul 2004
    Location
    bangalore
    Posts
    24
    If 64 bit then
    select ksmmmval from x$ksmmem where indx = 1;

    if 32 bit then
    select ksmmmval from x$ksmmem where indx = 2;
    Thanks and Regards,
    Satheesh Babu.S
    Bangalore

  7. #7
    Join Date
    Jul 2004
    Location
    bangalore
    Posts
    24
    Sorry,

    If 64 bit then
    select ksmmmval from x$ksmmem where indx = 1;

    if 32 bit then
    select ksmmmval from x$ksmmem where indx = 2;

    If any of the above query return version number properly then that's your bit size.
    Thanks and Regards,
    Satheesh Babu.S
    Bangalore

  8. #8
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    [code]
    tubairux6:dbadmin:gosuat2:sqlplus "/ as sysdba"

    SQL*Plus: Release 9.2.0.4.0 - Production on Tue Jul 27 12:49:19 2004

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.4.0 - Production

    SQL> select ksmmmval from x$ksmmem where indx = 2;

    KSMMMVAL
    ----------------
    0920040000000000

    SQL> select ksmmmval from x$ksmmem where indx = 1;

    KSMMMVAL
    ----------------
    00000EEE00000000
    [code]

    Mine is 64 bit, but the version is showing correctly in indx=2 which supposed to be 32 bit (according to your script).
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  9. #9
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by shans
    If 64 bit then
    select ksmmmval from x$ksmmem where indx = 1;

    if 32 bit then
    select ksmmmval from x$ksmmem where indx = 2;
    Where did you find this info and how accurate is this?? Definitely its not there in docs or metalink.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  10. #10
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    uhhh what's wrong with letting Oracle tell you which version it is when you log in? If it says 64bit that means it's a 64bit version of the database. If it doesn't say anything at all it's 32bit. Too easy! Work smarter not harder.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

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