-
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
-
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
-
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
-
'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
-
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.
-
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
-
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
-
[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).
-
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"
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|