方法一：使用sqlplus
64位：
[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, 2010, oracle. all rights reserved.
connected to:
oracle database 10g enterprise editionrelease 10.2.0.5.0 - 64bit production
with the partitioning, olap, data miningand real application testing options
sql>
如果是64位，，用sqlplus 连上之后会显示具体的位数信息，32位则不会显示。
32位：
c:\users\administrator.daviddai>sqlplus/ as sysdba;
sql*plus: release 11.2.0.1.0 production onsun sep 25 08:55:48 2011
copyright (c) 1982, 2010, oracle. all rights reserved.
connected to:
oracle database 11g enterprise editionrelease 11.2.0.1.0 - production
with the partitioning, olap, data miningand real application testing options
方法二： 查看v$version 视图32位：
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位：
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
和第一种方法一样，64位会显示具体的位数信息，32位不会显示。
方法三：查看v$sql 视图
32位：输出为8位16进制数
sql> select address from v$sql whererownum
address
--------
b50accac
64位：输出为16位16进制数
sql> select address from v$sql whererownum
address
----------------
0000000196fdf7d8