如何確定Oracle是32 Bit(位)的還是64 Bit(位)的?

主要有以下幾種方法可以用來確定Oracle的位元:
1.通過SQLPLUS登入即可看出

a.64位登入時就有顯示

$ sqlplus "/ as sysdba"SQL*Plus: Release 9.2.0.4.0 - Production on Wed Nov 16 15:27:28 2005Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Connected to:Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit ProductionWith the Partitioning optionJServer 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 2005Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.Connected to:Oracle9i Enterprise Edition Release 9.2.0.4.0 - ProductionWith the Partitioning optionJServer 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 - ProductionPL/SQL Release 9.2.0.6.0 - ProductionCORE 9.2.0.6.0 ProductionTNS for 32-bit Windows: Version 9.2.0.6.0 - ProductionNLSRTL 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 ..