Was this database created as 32-bit or 64-bit db?
By Martin | November 4th, 2009 | Category: Oracle Database | 3 commentsTo 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.
…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:
http://www.oracle.com/global/de/upgradecommunity/artikel/Upgrade11gR1_workshop1.pdf
Part2 covers even more information regarding upgrades:
http://www.oracle.com/global/de/upgradecommunity/artikel/Upgrade11gR1_workshop2.pdf
— connected
SELECT Length(addr)*4 || ‘-bits’ word_length FROM v$process WHERE ROWNUM =1;
— not connected
$ file $ORACLE_HOME/bin/oracle
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.
Regards,
Martin