Is my version of Oracle is 64 or 32 bit


There are a number of ways to check whether the version or Oracle you have installed is 64 bit or 32 bit.

Two ways to do so are described here

At the O/S type

file $ORACLE_HOME/bin/oracle

or log in to SQL*Plus and it should display 64 bit mode if 64 bit.

else type from SQL*Plus

select * from v$version;