| Finding 32/64 bit? [message #184398] |
Wed, 26 July 2006 07:35  |
msgforsunil
Messages: 26
Registered: November 2005
|
Junior Member |
|
|
I use the following command to check if whether Oracle is 32/64 bit.
select banner from v$version; which gives the following output
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Pr
PL/SQL Release 10.1.0.2.0 - Production
CORE 10.1.0.2.0 Production
TNS for 32-bit Windows: Version 10.1.0.2.0 - Production
NLSRTL Version 10.1.0.2.0 - Production
Do I consider it as 32 bit as I dont see either 32 or 64 as part of the output? Please clarify. I guess for 64 bit, we would see 64 as part of the output.
Please let me know is there any other way to know this?
[Updated on: Wed, 26 July 2006 08:08] Report message to a moderator |
|
|
|
| Re: Finding 32/64 bit? [message #185195 is a reply to message #184398] |
Mon, 31 July 2006 08:07  |
ramakris
Messages: 21
Registered: July 2006
Location: Delhi
|
Junior Member |
|
|
Hi-
You can get this information by querying PRODUCT_COMPONENT_VERSION.
select * from PRODUCT_COMPONENT_VERSION;
should give you what you want.
Thanks,
Rama.
|
|
|
|
| Re: Finding 32/64 bit? [message #185311 is a reply to message #185195] |
Tue, 01 August 2006 02:49 |
ehegagoka
Messages: 493
Registered: July 2005
|
Senior Member |
|
|
hi!
ive also tried that but it didnt give any about 32/64 bit?
SQL> /
PRODUCT VERSION STATUS
------------------------------ -------------------- ---------
NLSRTL 9.2.0.4.0 Production
Oracle9i Enterprise Edition 9.2.0.4.0 Production
PL/SQL 9.2.0.4.0 Production
TNS for Linux: 9.2.0.4.0 Production
|
|
|
|
| Re: Finding 32/64 bit? [message #185319 is a reply to message #185311] |
Tue, 01 August 2006 03:55 |
ramakris
Messages: 21
Registered: July 2006
Location: Delhi
|
Junior Member |
|
|
Well in that case you can try the mentioned query below:
prod:proddba > select address from V$sql where rownum < 2;
ADDRESS
----------------
C0000001FE9202C8
Now, 32-bit is represented by 8-HEX characters where as 64-bit is represented by 16-HEX characters.
In the above illustration we can see 16 hex characters and thus we can conclude that its a 64-bit database. Thus, if Oracle is running 32-bit mode then you will see an 8-character address and in 64-bit mode a 16-character address.
Thanks!
|
|
|
|
| Re: Finding 32/64 bit? [message #185344 is a reply to message #185319] |
Tue, 01 August 2006 05:12 |
ehegagoka
Messages: 493
Registered: July 2005
|
Senior Member |
|
|
hi!
so thats it, i didnt know our server runs on a 32-bit =) because this is the result =)
SQL> select address from v$sql where rownum < 2
2 /
ADDRESS
--------
6BB16B74
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
