Skip to content
Advertisements

Archive for

How do i check my oracle database is either 32 bit or 64bit

Have a lot of method…Here one method below

[oracle@netbackuptest bin]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 26 07:57:52 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select length(addr)*4 || '-bits' word_length from v$process where rownum=1;

WORD_LENGTH
---------------------------------------------
64-bits

SQL>
Advertisements