That it does, thanks so much :)
Thomas Kyte wrote:
>
> 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
Received on Fri Mar 29 2002 - 11:45:51 CST
