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 d

RE: Oracle - 32bit/64bit??

2002-07-23 Thread Adrian Roe
Just log into the database using sqlplus and it will tell you /u01/app/oracle>sqlplus / 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 Pro

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

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

Re: Further question: Oracle 32bit / 64bit

2001-07-19 Thread tday6
TED]> Sent by: cc: [EMAIL PROTECTED] Subject: Re: Further question: Oracle 32bit /

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

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 t

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

RE: Oracle 32bit / 64bit

2001-07-17 Thread Rao, Maheswara
Mitchell, We have both 32 bit and 64 bit Oracle 817 running on Solaris 7. The easiest way is --- When you log onto SQL, then you would get a message similar to following: Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64 bit production Now, if you are running 32 bit version, you get the follo

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

RE: Oracle 32bit / 64bit

2001-07-17 Thread Deshpande, Kirti
ly 17, 2001 2:38 PM > To: Multiple 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.

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 Message

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