Skip to content

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 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 - 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;


9 Comments Post a comment
  1. Neil Greene #

    Is there something wrong with the header?

    November 26, 2011
    • Can’t get to the header with SQL… 😉

      November 27, 2011
      • Select * from v$version;

        November 28, 2011
      • 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…

        November 28, 2011
  2. Shyfur #

    Excellent brooo

    January 24, 2012
  3. Azer #

    When you enter “sqlplus / as sysdba” in terminal window:

    Oracle Database 11g Enterprise Edition Release – 64bit 🙂

    February 10, 2012
    • Theresa #

      It doesn’t say what it is when it’s 32-bit, only when it’s 64-bit, at least for Oracle XE 11.

      November 14, 2017
  4. goto $ORACLE_HOME/bin/oracle
    file oracle

    Enjoy !

    May 1, 2012
  5. Krishna #

    Can u post another method

    April 30, 2013

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: