在Oracle中，如何判断Oracle是32位还是64位？

jiawang

方法一：使用SQL*Plus


如果是64位，那么用SQL*Plus连上之后会显示具体的位数信息，若是32位，则不会显示。


64位：
[oracle@sztech ~]$ sqlplus / as sysdba;


SQL*Plus: Release 11.2.0.4.0 - Productionon Sun Sep 25 08:57:22 2024


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


Connected to:


Oracle Database 11g Enterprise EditionRelease 11.2.0.4.0 - 64bit Production


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


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


32位：


C:\Users\Administrator>sqlplus/ as sysdba;


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


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 11g Enterprise EditionRelease 11.2.0.4.0 - 64bi


PL/SQL Release 11.2.0.4.0 - Production


CORE 11.2.0.4.0 Production


TNS for Linux: Version 11.2.0.4.0 -Production


NLSRTL Version 11.2.0.4.0 – Production


和第一种方法一样，64位会显示具体的位数信息，32位不会显示。


方法三：查看v$sql 视图
32位：输出为8位16进制数


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


ADDRESS


--------


B50ACCAC


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


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


ADDRESS


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


0000000196FDF7D8