oracle 32 or 64?

[Ratzie]

How to tell what is installed?

V$version does not tell me

[James R. Ferguson]

Hi:

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

Regards!

...JRF...

[Patti Johnson · Accepted solution]

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]

perfect!