How To Find Oracle Database 32 bit or 64 bit

Finding Oracle Database Version on your system through Operating System

$ cd $ORACLE_HOME

$ cd bin

$ file oracle

oracle:         ELF-64 executable object file – IA64

Finding Oracle Database Version on your system through SQL Prompt

SQL> select metadata from sys.kopm$ ;

METADATA

——————————————————————————–

0000006001240F050B0C030C0C0504050D0609070805050505050F05050505050A05050505050405

0607080823472347081123081141B0470083000107D0130000000000000000000000000000000000

0000000000000000000000000000000000000000

Here As you can See the Output Contains B4047 which means Database is 64-Bit Version.

If the Output contains B4023 then the Database is 32-Bit Version.