Oracle BIT info.

You need to determine if Oracle is running in 32-bit or 64-bit mode.

Solution:

One method of determining whether Oracle is running in 32-bit or 64-bit

is to check the address definition size of a database view which contains 

address information handles.

For example, the PADDR column in the V$SESSION view is the handle to the process 

which owns a database session.

If PADDR is a 8 hexadecimal number then Oracle is running in 32-bit.

If PADDR is a 16 hexadecimal number then Oracle is running in 64-bit. 

For example, a 32-bit Oracle database will display 

SQL> conn system/password

SQL> select paddr from v$session where username = 'SYSTEM';

PADDR

--------

A763A730

And a 64-bit Oracle will display

SQL> conn system/password

SQL> select paddr from v$session where username = 'SYSTEM';

PADDR

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

000000039125DF78

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

Question: Was the database created in 32 bit or 64 bit mode? 

Answer: 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 'BO23' then it indicates that the

database was created as 32-bit

If the output references the string 'BO47' then it indicates that the

database was created as 64-bit.