Check whether Oracle Installation is 32bit or 64bit

Run the PL/SQL Block bellow to check which Oracle is installed:

################################################
set serveroutput on
declare
v_metadata varchar2(1000);
v_plataform varchar2(1000);
begin

select metadata into v_metadata from sys.kopm$;

select substr(lpad(v_metadata,112),109,4) into v_plataform from dual;

if v_plataform = 'B023' then
dbms_output.put_line(a => 'My Oracle installation is ----32bit----!');
else
dbms_output.put_line(a => 'My Oracle installation is ----64bit----!');
end if;

end;
/
################################################

Or just check oracle file in $ORACLE_HOME/bin:
--64 bit example
$ file oracle
oracle: setuid setgid ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.6.9, dynamically linked (uses shared libs), for GNU/Linux 2.6.9, not stripped

--32bit example:
$ file oracle
oracle: setuid setgid ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.2.5, dynamically linked (uses shared libs), not stripped



Best Regards,
Paulo Portugal