Skip to content
Advertisements

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
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 11.2.0.2.0 – 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:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: