How can we determine whether Oracle is a 32-bit or 64-bit oracle?

The following methods can be used to determine the number of Oracle digits:
1. You can see through sqlplus Login

A.64-bit logon is displayed

$ Sqlplus "/As sysdba" SQL * Plus: Release 9.2.0.4.0-production on Wed Nov 16 15:27:28 2005 copyright (c) 1982,200 2, 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-bit undisplayed

[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,200 2, 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. Obtain from 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. Obtain from V $ SQL View
A. If the output is an 8-bit hexadecimal number, it is a 32-bit Oracle

SQL> select address from V $ SQL where rownum <2; ADDRESS--------578428D8

B. If the output is a 16-bit hexadecimal number, it is a 64-bit Oracle

SQL> select address from V $ SQL where rownum <2; ADDRESS----------------000000040DFA01E0

3. Use the system command file

A. If the output contains 32-bit 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. If the output contains 64-bit characters

$ File $ ORACLE_HOME/bin/Oracle/opt/Oracle/product/9.2.0/bin/Oracle: elf 64-bit MSB executable sparcv9 version 1 ..