怎么查看安装的oracle是32位的还是64位
发布网友
发布时间:2022-04-13 23:47
我来回答
共1个回答
热心网友
时间:2022-04-14 01:16
查看v$version 视图
操作示例:
32位:
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------
Oracle Database 11g Enterprise EditionRelease 11.2.0.1.0 - Proction
PL/SQL Release 11.2.0.1.0 - Proction
CORE 11.2.0.1.0 Proction
TNS for 32-bit Windows: Version 11.2.0.1.0- Proction
NLSRTL Version 11.2.0.1.0 - Proction
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 - Proction
CORE 10.2.0.5.0 Proction
TNS for Linux: Version 10.2.0.5.0 -Proction
NLSRTL Version 10.2.0.5.0 – Proction
PS:64位会显示具体的位数信息,32位不会显示。