怎么看自己oracle位数,查看 Oracle 位数的方法

1、使用sqlplus命令

[rac11g1@oracle]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Wed Feb 15 16:19:43 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bitProduction

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

如果是64位，用sqlplus 连上之后会显示具体的位数信息，32位则不会显示。

[oracle@srccat ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Wed Feb 15 16:11:47 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

16:19:43 nint1@SYS>

2、查看v$version视图

16:21:30 nint1@SYS> select * from v$version;

BANNER

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

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bitProduction

PL/SQL Release 11.2.0.2.0 - Production

CORE    11.2.0.2.0      Production

TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production

NLSRTL Version 11.2.0.2.0 - Production

64位会显示具体的位数信息，同样的32位不会显示

16:11:47 srcbtest@SYS> select * from v$version;

BANNER

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

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod

PL/SQL Release 10.2.0.4.0 - Production

CORE    10.2.0.4.0      Production

TNS for Linux: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

3、查看v$sql视图中的address

64位：输出为16位16进制数

16:21:38 nint1@SYS> select address from v$sql where rownum <2;

ADDRESS

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

07000005EFA5EEE8

32位：输出为8位16进制数

16:13:23 srcbtest@SYS> select address from v$sql where rownum <2; ADDRESS -------- 9FE49FAC