Shulou(Shulou.com)06/01 Report--

Oracle Study-- check the Oracle version of the operation word length (32 max 64-bit) method

First, use sqlplus to view

64-bit:

[oracle@rh7 ~] $sqlplus'/ as sysdba'

SQL*Plus: Release 11.2.0.3.0 Production on Wed Jun 24 14:14:10 2015

Copyright (c) 1982, 2011, 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:

[oracle@rh65] $! sql

Sqlplus'/ as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 24 14:20:50 2015

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

Connected to an idle instance.

2. Check 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-bit, the specific bit information will be displayed after connecting with sqlplus, while 32-bit will not be displayed.

3. Check v$sql

64-bit:

SQL > select address from v$sql where rownum select address from v$sql where rownum

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.