RE: Oracle - 32bit/64bit??

2002-07-23 Thread Adrian Roe
Just log into the database using sqlplus and it will tell you /u01/app/oraclesqlplus / SQL*Plus: Release 9.0.1.0.0 - Production on Tue Jul 23 10:16:50 2002 (c) Copyright 2001 Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit

RE: Oracle - 32bit/64bit??

2002-07-23 Thread Vikas Khanna
If 64 bit then Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit Production else Oracle9i Enterprise Edition Release 9.0.1.2.0 end if; Vikas Khanna -Original Message- Sent: Tuesday, July 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Just log into the

Oracle - 32bit/64bit??

2002-07-22 Thread elain he
Hi, Does anyone know how I can verify if a database is 32 or 64 bit? Thanks. elain _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: Oracle - 32bit/64bit??

2002-07-22 Thread kkennedy
As someone mentioned on the list, not too recently, use the following command: file $ORACLE_HOME/bin/oracle On my machine with 32 bit Oracle, I get: /keg2/oracle/product/8.1.7/bin/oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped HTH Kevin Kennedy First Point

Re: Further question: Oracle 32bit / 64bit

2001-07-19 Thread paquette stephane
The main problem with Oracle 816 64 bit Solaris is that is it so late behind in term of patches. 8163 is not available yet ! --- [EMAIL PROTECTED] a écrit : Last time that I installed Oracle 8.1.6 on a Sun 64 bit OS I installed the 64 bit version. If you pressed me real hard as to why I

Re: Further question: Oracle 32bit / 64bit

2001-07-19 Thread tday6
32bit / 64bit 07/19/2001 10:05 AM

Re: Further question: Oracle 32bit / 64bit

2001-07-18 Thread tday6
Last time that I installed Oracle 8.1.6 on a Sun 64 bit OS I installed the 64 bit version. If you pressed me real hard as to why I did that, the best that I could say is that it seemed like a good idea at the time. Some vague idea that the 64 bit version would work better (more optimally) with

Re: Oracle 32bit / 64bit

2001-07-17 Thread Mitchell
Dear DBAs How can I know my Oracle running on 32 or 64bit ? I am considering change configuration of SGA. Currently OS is updated to 8g memory on aix 4.3.3. The limit is 2gb for 32bit ? I only know if you switch from 32bit to 64bit or vice-a-versa, then you also need to run UTLIRP.SQL script

RE: Oracle 32bit / 64bit

2001-07-17 Thread Christopher Spence
Easiest way I know is do a select * from v$session, if the session id is 8 digits your running 32 bit, if it is 16 your running 64 bit. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original

RE: Oracle 32bit / 64bit

2001-07-17 Thread Deshpande, Kirti
recipients of list ORACLE-L Subject: Re: Oracle 32bit / 64bit Dear DBAs How can I know my Oracle running on 32 or 64bit ? I am considering change configuration of SGA. Currently OS is updated to 8g memory on aix 4.3.3. The limit is 2gb for 32bit ? I only know if you switch from

RE: Oracle 32bit / 64bit

2001-07-17 Thread Kimberly Smith
Actually, as soon as you sign onto SQL*Plus is good enough. Oracle8i Enterprise Edition Release 8.1.5.0.0, 64 bit - Production Oracle8i Enterprise Edition Release 8.1.7.1.0 - Production Note the difference between the two. -Original Message- Sent: Tuesday, July 17, 2001 1:00 PM To:

Further question: Oracle 32bit / 64bit

2001-07-17 Thread Dan . Hubler
OK help me out here... We are contemplating moving up to the new Sun/Solaris sunfire architecture, which is a 64-bit platform. We would be moving from multiple Solaris 32-bit machines. What are my options as far as running Oracle 8.1.6.x? Upgrade? Re-install