Oracle Study-View Oracle version operation Word length (32/64 bit) method

Oracle Study-View Oracle version operation Word length (32/64 bit) method

First, using Sqlplus view

64-bit:

[Email protected] ~]$ sqlplus '/as sysdba '

Sql*plus:release 11.2.0.3.0 Production on Wed June 24 14:14:10 2015

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

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
With the partitioning, OLAP, Data Mining and Real application testing options

Sql>

32-bit:

[Email protected] ~]$!sql
Sqlplus '/as sysdba '

Sql*plus:release 11.2.0.1.0 Production on Wed June 24 14:20:50 2015

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

Connected to an idle instance.

Second, view version

64-bit:

Sql> select * from V$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit Production
PL/SQL Release 11.2.0.3.0-production
CORE 11.2.0.3.0 Production
TNS for Linux:version 11.2.0.3.0-production
Nlsrtl Version 11.2.0.3.0-production

32-bit:

Sql> select * from V$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-production
PL/SQL Release 11.2.0.1.0-production
CORE 11.2.0.1.0 Production
TNS for Linux:version 11.2.0.1.0-production
Nlsrtl Version 11.2.0.1.0-production

If it is 64 bits, the specific bit information will be displayed after connecting with Sqlplus, and 32 bits will not be displayed.

Third, view V$sql
64-bit:

Sql> Select address from v$sql where RowNum <2;

ADDRESS
----------------
00000000788e0a20

32-bit:
Sql> Select address from v$sql where RowNum <2;

ADDRESS
--------
69a9e378

64-bit output is 16-bit 16-binary, 32-bit output is 8-bit 16-binary number

This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1665057

Oracle Study-View Oracle version operation Word length (32/64 bit) method