64-bit or 32-bit word size? 
Author Message
 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



Tue, 14 Sep 2004 23:05:32 GMT
 64-bit or 32-bit word size?


Quote:

>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)

Quote:
>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

--

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


Wed, 15 Sep 2004 00:43:23 GMT
 64-bit or 32-bit word size?
That it does, thanks so much :)
Quote:


> >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

> --

> 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



Wed, 15 Sep 2004 01:45:51 GMT
 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

Quote:

> 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



Wed, 15 Sep 2004 05:30:22 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. 64-bit SQL Server and 32-bit dlls question

2. 32-bit Oracle Server on 64-bit Solaris?

3. Performance: 32-bit SE vs. 64-bit EE

4. Changes in 64 bit Oracle from 32 bit

5. Moving from 8.1.7 32-bit to 8.1.7 64-bit

6. 32-bit Clients to 64-bit Oracle Server

7. 8.0.5 32-bit on HP-UX 11.0 64-bit

8. 32-bit client to 64-bit server

9. 64 bit client accessing 32 bit server?

10. Upper limit of total SGA for 32-bit Oracle8i Release 3 on 64-bit Solaris 8

11. Porting 32-bit to 64-bit on Sun Solaris

12. Help needed on moving data from 32-bit to 64-bit


 
Powered by phpBB® Forum Software