Check whether Oracle32-bit or 64-bit (x86orx64)

Check whether Oracle32-bit or 64-bit (x86orx64)

Method 1: Use sqlplus

### 64-bit: [oracle @ db01 ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.3.0 Production on Fri Oct 318: 44: 05 2014 Copyright (c) 1982,201 1, Oracle. all rights reserved. connected to: Oracle Database 11g Enterprise Edition Release11.2.0.3.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and RealApplication Testing options SQL> if it is 64-bit, after sqlplus is connected, the specific number of digits is displayed, and 32 bits are not displayed. ### 32-bit: [oracle @ db01 ~] $ Sqlplus/as sysdba; SQL * Plus: Release 11.2.0.1.0 Production onSun Sep 2508: 55: 48 2011 Copyright (c) 1982,201 0, Oracle. all rightsreserved. connected to: Oracle Database 11g Enterprise EditionRelease11.2.0.1.0-ProductionWith the Partitioning, OLAP, Data Miningand RealApplication Testing options

Method 2: view the v $ version view

### 32-bit: SQL> select * from v $ version; BANNER implements Oracle Database 11g Enterprise EditionRelease11.2.0.1.0-ProductionPL/SQL Release 11.2.0.1.0-ProductionCORE 11.2.0.1.0 ProductionTNS for 32-bit Windows: version 11.2.0.1.0-ProductionNLSRTL Version 11.2.0.1.0-Production ### 64-bit: SQL> select * from v $ version; BANNER indexing Oracle Database 11g Enterprise Edition Release11.2.0.3.0-64bit ProductionPL/SQL Release 11.2.0.3.0-ProductionCORE 11.2.0.3.0 ProductionTNS for Linux: Version 11.2.0.3.0-ProductionNLSRTL Version 11.2.0.3.0-Production

Like the first method, 64-bit displays the specific number of digits, and 32-bit does not.

Method 3: view the v $ SQL View

### 32-bit: 8-bit hexadecimal output SQL> select address from v $ SQL whererownum <2; ADDRESS--------B50ACDAE ### 64-bit: output as 16-bit hexadecimal SQL> select address from v $ SQL whererownum <2; ADDRESS----------------00000000C18D79C8