Home » RDBMS Server » Server Administration » Finding 32/64 bit?
Finding 32/64 bit? [message #184398] Wed, 26 July 2006 07:35 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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

Re: Finding 32/64 bit? [message #185351 is a reply to message #185344] Tue, 01 August 2006 05:28 Go to previous message
ramakris
Messages: 21
Registered: July 2006
Location: Delhi
Junior Member
The result you got shows that your server is a 32-bit server as you can see 8 hex characters in that.

So that's it..

Thanks!
Previous Topic: Listeners Conflict due to 10g Grid Control
Next Topic: Business Objects Repository TableSpace issue
Goto Forum:
  


Current Time: Sun Dec 04 06:50:34 CST 2016

Total time taken to generate the page: 0.08626 seconds