查看Oracle 32位還是64位(x86 or x64)

標籤：style   color   io   使用   ar   for   strong   sp   2014   

方法一：使用sqlplus

###64位：[[email protected] ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 318:44:05 2014 Copyright (c) 1982, 2011, Oracle.  All rights reserved. Connected to:Oracle Database 11g Enterprise Edition Release11.2.0.3.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and RealApplication Testing options SQL> 如果是64位，用sqlplus 連上之後會顯示具體的位元資訊，32位則不會顯示。  ###32位：[[email protected] ~]$sqlplus/ as sysdba; SQL*Plus: Release 11.2.0.1.0 Production onSun Sep 2508:55:48 2011 Copyright (c) 1982, 2010, Oracle.  All rightsreserved. Connected to:Oracle Database 11g Enterprise EditionRelease11.2.0.1.0 - ProductionWith the Partitioning, OLAP, Data Miningand RealApplication Testing options

方法二：查看v$version視圖

###32位：SQL> select * from v$version; BANNER--------------------------------------------------------------------------Oracle Database 11g Enterprise EditionRelease11.2.0.1.0 - ProductionPL/SQL Release 11.2.0.1.0 - ProductionCORE   11.2.0.1.0     ProductionTNS for 32-bit Windows: Version 11.2.0.1.0- ProductionNLSRTL Version 11.2.0.1.0 - Production ###64位：SQL> select * from v$version; BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release11.2.0.3.0 - 64bit ProductionPL/SQL Release 11.2.0.3.0 - ProductionCORE   11.2.0.3.0      ProductionTNS for Linux: Version 11.2.0.3.0 - ProductionNLSRTL Version 11.2.0.3.0 – Production

和第一種方法一樣，64位會顯示具體的位元資訊，32位不會顯示。

 

方法三：查看v$sql視圖

###32位：輸出為8位16進位數SQL> select address from v$sql whererownum<2; ADDRESS--------B50ACDAE ###64位：輸出為16位16進位數SQL> select address from v$sql whererownum<2; ADDRESS----------------00000000C18D79C8

查看Oracle 32位還是64位(x86 or x64)