Using the following SQL one can find the oracle bit version installed:

SQL> SELECT length(addr)*4 || ‘-bit’ word_length FROM v$process where rownum=1;

WORD_LENGTH
—————
64-bit

• General DBA