Oracle Bit version:
From Linux/Unix prompt:
$file `which oracle`
/oracle/app/oracle/product/10.2.0/db_1/bin/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
From here you can find, oracle BIT version.
From sql prompt:
select distinct address from v$sql where rownum<2;
ADDRESS
-----------
0000000386D3E060
If the address is 16 characters long, it is 64 bit.
If it is 32 bit you will get an 8 character address.
SQL> select distinct address from v$sql where rownum<2;
ADDRESS
-----------
826A774C
From Linux/Unix prompt:
$file `which oracle`
/oracle/app/oracle/product/10.2.0/db_1/bin/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
From here you can find, oracle BIT version.
From sql prompt:
select distinct address from v$sql where rownum<2;
ADDRESS
-----------
0000000386D3E060
If the address is 16 characters long, it is 64 bit.
If it is 32 bit you will get an 8 character address.
SQL> select distinct address from v$sql where rownum<2;
ADDRESS
-----------
826A774C
Comments