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

Check out metalinks, they'll tell you to do the following:

On Solaris, go to your $ORACLE_HOME/bin and execute the following command at the os
SOLARIS>file oracle

I get the following output:
oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, n
If it's running 64bit, you'll get a mention of it in here. The other way in which i've found is fire up sqlplus and on the header text that comes out for every login, it should show 64bit in the message.

HTH,
Pete's

Mike Jay <mikejay_at_mitre.org> wrote in message news:<3CA482BC.7618A4D2_at_mitre.org>...
> 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 - 15:30:22 CST