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

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!