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>
9 Comments
Post a comment
DBA 
Is there something wrong with the header?
Can’t get to the header with SQL… 😉
Select * from v$version;
Good catch. But still murder to figure out if it is 64 or 32, unless one reads it.
The method explained here is direct and gives the word length without any other noise.
There is likely other places to get it from as well…
Excellent brooo
When you enter “sqlplus / as sysdba” in terminal window:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – 64bit 🙂
It doesn’t say what it is when it’s 32-bit, only when it’s 64-bit, at least for Oracle XE 11.
goto $ORACLE_HOME/bin/oracle
file oracle
Enjoy !
Can u post another method