View Oracle 32-bit or 64-bit (x86 or x64)

method One: Use Sqlplus

# # #64位: [[email protected] ~]$ sqlplus/as sysdba sql*plus:release 11.2.0.3.0 Production on Fri Oct 318:44:05 Copyri Ght (c) 1982, 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 bits, the specific bit information will be displayed after the Sqlplus connection, and 32 bits will not be displayed.  # # #32位: [[email protected] ~] $sqlplus/as sysdba; Sql*plus:release 11.2.0.1.0 Production Onsun Sep 2508:55:48-Copyright (c) 1982, Oracle.  All rightsreserved. Connected to:oracle Database 11g Enterprise editionrelease11.2.0.1.0-productionwith The partitioning, OLAP, Data Mininga ND realapplication Testing options

Method Two: View v$version View

# # #32位:sql> select * from V$version; BANNER--------------------------------------------------------------------------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位:sql> select * from V$versio N BANNER--------------------------------------------------------------------------------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

As with the first method, -Bit will display the exact number of digits, +bits are not displayed.

method Three: View V$sql View

# # #32位: Output is 8-bit 16 binary sql> Select address from V$sql whererownum<2; ADDRESS--------B50acdae # # #64位: Output is 16-bit 16 decimal sql> Select address from V$sql whererownum<2; ADDRESS----------------00000000c18d79c8

View Oracle 32-bit or 64-bit (x86 or x64)