Database created 32-bit or 64-bit?

To identify whether a database was created as 32-bit or 64-bit, execute the following SQL statement:

SQL> select metadata from sys.kopm$;

If the output references the string 'B023' then it indicates that the database was created as 32-bit

If the output references the string 'B047' then it indicates that the database was created as 64-bit

NOTE: The second character is the digit zero, not an upper-case letter 'o'

sys@TOY10G> select metadata from sys.kopm$ ;

METADATA

----------------------------------------------------------------------------------------------------

0000006001240F050B0C030C0C0504050D0609070805050505050F05050505050A0505050505040506070808234723470811

23081141B0470083000107D01300000000000000000000000000000000000000000000000000000000000000000000000000

sys@GENQA> select metadata from sys.kopm$;

METADATA

----------------------------------------------------------------------------------------------------

0000006001210F050B0C030C0C0504050D06090708050F0505050F05050505050A0505050505040508234723230811230811

41B0230083002700271300000000000000000000000000000000000000000000000000000000000000000000000000000000