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