Re: 64-bit or 32-bit word size?

In article <3CA482BC.7618A4D2_at_mitre.org>, Mike says...
>
>Good morning,
>

$ cd $ORACLE_HOME/bin
$ file oracle

should tell you -- for example on solaris:

$ file oracle
oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped

or HP/UX:

$ file oracle
oracle: ELF-64 executable object file - PA-RISC 2.0 (LP64)

>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

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp