How to see if Oracle is 32-bit or 64-bit

Method One: Use Sqlplus

64-bit:

[Oracle@qs-wg-db2 ~]$ Sqlplus/as sysdba;

Sql*plus:release 10.2.0.5.0-productionon Sun Sep 25 08:57:22 2011

Copyright (c) 1982, Oracle. All Rights Reserved.

Connected to:

Oracle Database 10g Enterprise editionrelease 10.2.0.5.0-64bit Production

With the partitioning, OLAP, Data miningand Real application testing options

Sql>

If it is 64 bits, the exact bit information will be displayed after the Sqlplus is connected, and 32 bits will not be displayed.

32-bit:

C:\users\administrator.daviddai>sqlplus/as Sysdba;

Sql*plus:release 11.2.0.1.0 Production Onsun Sep 25 08:55:48 2011

Copyright (c) 1982, Oracle. All rights reserved.

Connected to:

Oracle Database 11g Enterprise editionrelease 11.2.0.1.0-production

With the partitioning, OLAP, Data miningand Real application testing options

Method Two: View the V$version view

32-bit:

Sql> select * from V$version;

BANNER

--------------------------------------------------------------------------

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

Oracle Database 11g Enterprise editionrelease 11.2.0.1.0-production

Pl/sql Release 11.2.0.1.0-production

CORE 11.2.0.1.0 Production

TNS for 32-bit windows:version 11.2.0.1.0-production

Nlsrtl Version 11.2.0.1.0-production

64-bit:

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-production

CORE 10.2.0.5.0 Production

TNS for Linux:version 10.2.0.5.0-production

Nlsrtl Version 10.2.0.5.0–production

As with the first method, 64 bits display specific bits of information, and 32 bits do not display.

Method Three: View the V$sql view

32-bit: output is 8-bit 16 in number

Sql> Select address from V$sql whererownum<2;

Address

--------

B50accac

64-bit: Output is 16-bit 16 in number

Sql> Select address from V$sql whererownum<2;

Address

----------------

0000000196fdf7d8

This article is from the "Technical Knowledge exchange" blog, please be sure to keep this source http://xiahouyao123.blog.51cto.com/646312/861786