如何確定Oracle是32 Bit(位)的還是64 Bit(位)的?
2024-08-29 13:42:26
供稿：網友
主要有以下幾種方法可以用來確定Oracle的位數:
1.通過SQLPLUS登錄即可看出
a.64位登錄時就有顯示
$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - PRodUCtion on Wed Nov 16 15:27:28 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
b.32位的無顯示
[oracle@jumper oracle]$ sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Wed Nov 16 15:19:03 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
c.從v$version獲取
SQL> select * from v$version;
BANNER
------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
PL/SQL Release 9.2.0.6.0 - Production
CORE 9.2.0.6.0 Production
TNS for 32-bit Windows: Version 9.2.0.6.0 - Production
NLSRTL Version 9.2.0.6.0 - Production
2.從v$sql視圖獲取
a.假如輸出為8位16進制數，則為32位Oracle
SQL> select address from v$sql where rownum<2;
ADDRESS
--------
578428D8
b.假如輸出為16位16進制數，則為64位Oracle
SQL> select address from v$sql where rownum<2;
ADDRESS
----------------
000000040DFA01E0
3.使用系統命令file
a.假如輸出帶有32-bit字樣為32位Oracle
[oracle@jumper oracle]$ file $ORACLE_HOME/bin/oracle
/opt/oracle/product/9.2.0/bin/oracle: setuid setgid ELF 32-bit LSB executable, Intel 80386..
b.假如輸出帶有64-bit字樣為64位Oracle
$ file $ORACLE_HOME/bin/oracle
/opt/oracle/product/9.2.0/bin/oracle: ELF 64-bit MSB executable SPARCV9 Version 1 ..
