Check whether Oracle is 32-bit or 64-bit

Method 1: Use sqlplus

64-bit:

[Oracle @ qs-wg-db2 ~] $ Sqlplus/as sysdba;

 

SQL * Plus: Release 10.2.0.5.0-Productionon Sun Sep 25 08:57:22 2011

 

Copyright (c) 1982,201 0, Oracle. All Rights Reserved.

 

 

Connected:

Oracle Database 10g Enterprise EditionRelease 10.2.0.5.0-64bit Production

With the Partitioning, OLAP, Data Miningand Real Application Testing options

 

SQL>

 

If it is 64-bit, the specific bit information is displayed after sqlplus is connected, and 32-bit information is not displayed.

 

 

32-bit:

C: \ Users \ Administrator. David Dai> sqlplus/as sysdba;

 

SQL * Plus: Release 11.2.0.1.0 Production onSun Sep 25 08:55:48 2011

 

Copyright (c) 1982,201 0, Oracle. All rights reserved.

 

 

Connected:

Oracle Database 11g Enterprise EditionRelease 11.2.0.1.0-Production

With the Partitioning, OLAP, Data Miningand Real Application Testing options

 

 

Method 2: view the v $ version view

32-bit:

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-bit:

SQL> select * from v $ version;

 

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise EditionRelease10.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

 

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: the output is an 8-bit hexadecimal number.

SQL> select address from v $ SQL whererownum <2;

 

ADDRESS

--------

B50ACCAC

 

64-bit: the output is a 16-bit hexadecimal number.

SQL> select address from v $ SQL whererownum <2;

 

ADDRESS

----------------

2017000196fdf7d8