topic Re: oracle 32 or 64? in Operating System - HP-UX

oracle 32 or 64?

Ratzie — Wed, 18 Jan 2006 14:40:49 GMT

How to tell what is installed?

V$version does not tell me

Re: oracle 32 or 64?

James R. Ferguson — Wed, 18 Jan 2006 14:50:11 GMT

Hi:

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

Regards!

...JRF...

Re: oracle 32 or 64?

Patti Johnson — Wed, 18 Jan 2006 15:27:46 GMT

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

Re: oracle 32 or 64?

Ratzie — Wed, 18 Jan 2006 15:40:15 GMT

perfect!