cancel
Showing results for 
Search instead for 
Did you mean: 

oracle 32 or 64?

SOLVED
Go to solution
Ratzie
Super Advisor

oracle 32 or 64?

How to tell what is installed?

V$version does not tell me
3 REPLIES
James R. Ferguson
Acclaimed Contributor

Re: oracle 32 or 64?

Hi:

A 'file' on the various binaries will show "ELF-64" for 64-bit binaries if they are 64-bit.

Regards!

...JRF...
Patti Johnson
Respected Contributor
Solution

Re: oracle 32 or 64?

James is correct.

Also v$version will tell you if it is 64-bit, but the 32-bit version does not say "32-bit"

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.0.1.4.0 - 64bit Production
PL/SQL Release 9.0.1.4.0 - Production
CORE 9.0.1.2.0 Production
TNS for HPUX: Version 9.0.1.4.0 - Production
NLSRTL Version 9.0.1.4.0 - Production
Ratzie
Super Advisor

Re: oracle 32 or 64?

perfect!