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