Was this database created as 32-bit or 64-bit db?

To find out whether the database was initially created as a 32-bit or 64-bit database, you can query:

SQL> select metadata from sys.kopm$ ;

When the output contains:  ‘B023‘ , the database was created as 32-bit whereas ‘B047‘ indicates 64-bit.
BTW: A short introduction to converting a database from Linux x86-32 to Linux x86-64 is available in MetaLink Note 341880.1.

Leave a comment »

  1. …to add an example what that could be useful for:
    The initial wordsize might be important if you plan to upgrade your database. For more details, see page 20 of Mike Dietrich’s excellent database upgrade paper:
    Part2 covers even more information regarding upgrades:

  2. — connected
    SELECT Length(addr)*4 || ‘-bits’ word_length FROM v$process WHERE ROWNUM =1;

    — not connected
    $ file $ORACLE_HOME/bin/oracle

  3. Sandro,

    thank you for participating and pointing out how to determine the current bit-platform of the running instance or binaries. It may well be that on a Linux x86-64 system, Oracle 32bit binaries have been installed, although that is not supported by Oracle.


Leave Comment