How to check whether oracle is 64 or 32 bit

Viewing method: 1. Execute the "sqlpus / as sysdba" command to enter sqlplus; 2. Execute the "select * from v$version;" command to view the digit information. If "64bit" is displayed, it is 64-bit. , if the specific number of bits is not displayed, it is 32 bits.

#The operating environment of this tutorial: linux5.9.8 system, Oracle 11g version, Dell G3 computer.

How to check whether Oracle is 64 or 32-bit

1. Enter sqlplus

sqlpus / as sysdba

2. Check

select * from v$version;

The host I checked is installed with 64bit oracle

##PS: 64 Bits will display specific digit information, 32-bit will not be displayed.

32 digits:

SQL> select * from v$version;
BANNER
-------------------------------------------------------------------------------
Oracle Database 11g Enterprise EditionRelease 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0- Production
NLSRTL Version 11.2.0.1.0 - Production

64 digits:

SQL> select * from v$version;
BANNER
-----------------------------------------------------------------
Oracle Database 10g Enterprise EditionRelease 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 -Production
NLSRTL Version 10.2.0.5.0 – Production

Recommended tutorial: "

OracleTutorial》

The above is the detailed content of How to check whether oracle is 64 or 32 bit. For more information, please follow other related articles on the PHP Chinese website!