32-bit Oracle (Windows 2000)
select address from v$sql where rownum < 2;
ADDRESS
——–
78435920
64-bit Oracle (TRU64 5.1)
select address from v$sql where rownum < 2;
ADDRESS
—————-
78BA1040787F3E44
AIX
# lslpp -h bos.rte
(only AIX 5.0 and 5.1 have 64-bit kernels)
SUN Solaris
% isainfo -kv
64-bit sparcv9 kernel modules
HP-UX 11.00 and later
$ getconf KERNEL_BITS
64
select * from v$version