64-bit or 32-bit word size?

Good morning,

How does one query a given instance, or find the IFILE, to check whether oracle is running 64-bit or 32-bit word size? I could not find out how using Oracle8i Installation Guide for Sun SPARC Solaris.

For the 8.1.6 instance:

SELECT * FROM V$VERSION;
BANNER
Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production PL/SQL Release 8.1.6.0.0 - Production
CORE 8.1.6.0.0 Production
TNS for Solaris: Version 8.1.6.0.0 - Production NLSRTL Version 3.4.0.0.0 - Production

For the Solaris 5.7 system:

$ /usr/bin/isainfo -kv

64-bit sparcv9 kernel modules

$ /usr/bin/ulimit -Sa

time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        8192
coredump(blocks)     unlimited
nofiles(descriptors) 64
vmemory(kbytes)      unlimited



$ /usr/bin/ulimit -Ha

time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        unlimited
coredump(blocks)     unlimited
nofiles(descriptors) 1024
vmemory(kbytes)      unlimited

Any help would be really appreciated.

Thanks,
-mikejay Received on Fri Mar 29 2002 - 09:05:32 CST