Database Created as 32bit Or 64bit Platform

We can check the Database Created as 32bit Or 64bit Platform through below sql query

SQL> select metadata from sys.kopm$ ;
METADATA

-----------------------------------------------------------0000006001240F050B0C030C0C0504050D0609070805050505050F05050505050A05050505050405
0607080823472323081123081141B023008300B207D0030000000000000000000000000000000000
0000000000000000000000000000000000000000

If above Colored Character Is "B023" means 32bit

Or

If it is "B047" means 64bit.

Thanks.

more ways to check oracle is 32 bit or 64 bit by using the following methods

1. You can retrieve this information from the data dictionary view v$version. Banner will tell you 64-bit if the 64-bit version is installed.If it does not specify 64-bit then it is 32-bit (although it does not explicitly say so). Same information you get when login into SQL*PLUS.

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

2. On Unix, the file command is also available . Example:

ORACLE:/home/oracle>file `which oracle`
/d01/app/oracle/product/10.2.0/db_1/bin/oracle: setuid setgid ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.2.5, dynamically linked (uses shared libs), not stripped

3.by quering v$process view

SQL> select length(addr)*4 || '-bits' word_length
2 from v$process
3 where rownum=1;

WORD_LENGTH
---------------------------------------------
32-bits

4.Check for lib, lib32

1) $ORACLE_HOME/lib32
2) $ORACLE_HOME/lib

If the two directories $ORACLE_HOME/lib32 and $ORACLE_HOME/lib are existing then it is 64 bit.

If there is only an ORACLE_HOME/lib directory then it is 32 bit client.