RE: Oracle - 32bit/64bit??
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 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 Production With the Partitioning option JServer Release 9.0.1.2.0 - Production SQL> -Original Message- Sent: 23 July 2002 00:09 To: Multiple recipients of list ORACLE-L 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 -- Author: elain he INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Khanna INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle - 32bit/64bit??
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 Production With the Partitioning option JServer Release 9.0.1.2.0 - Production SQL> -Original Message- Sent: 23 July 2002 00:09 To: Multiple recipients of list ORACLE-L 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 -- Author: elain he INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle - 32bit/64bit??
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 Energy Corporation -Original Message- Sent: Monday, July 22, 2002 4:09 PM To: Multiple recipients of list ORACLE-L 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 -- Author: elain he INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kkennedy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle - 32bit/64bit??
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 -- Author: elain he INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Further question: Oracle 32bit / 64bit
Good point. paquette stephane <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Re: Further question: Oracle 32bit / 64bit 07/19/2001 10:05 AM Please respond to ORACLE-L 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 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 > the 64 bit OS. I haven't seen anything to make me > think that the 32 bit > version would have been a better choice. > > On the other hand, it was a new installation, not a > migration of an > existing database. I don't know if there are any > problems with migrating a > 32 bit version database to 64 bit. > > Finally, the Oracle installation manual seems to > assume the 32 bit version. > As I remember we had to tweak the kernel parameters > to get the database to > mount and open. Don't remember which. Fortunately, > you don't have to > reboot to get the changes to take effect. > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Further question: Oracle 32bit / 64bit
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 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 > the 64 bit OS. I haven't seen anything to make me > think that the 32 bit > version would have been a better choice. > > On the other hand, it was a new installation, not a > migration of an > existing database. I don't know if there are any > problems with migrating a > 32 bit version database to 64 bit. > > Finally, the Oracle installation manual seems to > assume the 32 bit version. > As I remember we had to tweak the kernel parameters > to get the database to > mount and open. Don't remember which. Fortunately, > you don't have to > reboot to get the changes to take effect. > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Further question: Oracle 32bit / 64bit
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 the 64 bit OS. I haven't seen anything to make me think that the 32 bit version would have been a better choice. On the other hand, it was a new installation, not a migration of an existing database. I don't know if there are any problems with migrating a 32 bit version database to 64 bit. Finally, the Oracle installation manual seems to assume the 32 bit version. As I remember we had to tweak the kernel parameters to get the database to mount and open. Don't remember which. Fortunately, you don't have to reboot to get the changes to take effect. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Further question: Oracle 32bit / 64bit
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 and move data? Run Oracle 32-bit on the 64-bit platform? Thanks. -- Forwarded by Dan Hubler/DS/MICORP on 07/17/2001 03:33 PM --- "Rao, Maheswara" <[EMAIL PROTECTED]>@fatcity.com on 07/17/2001 04:10:46 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: 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 following message Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production Please observe that the above message is not telling whether it is 32 or 64. But for 64 bit, the message specifically tells you. Thanks, Rao -Original Message- Sent: Tuesday, July 17, 2001 3:38 PM To: Multiple recipients of list ORACLE-L 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 which recompiles all PL/SQL modules and alters certain dictionary tables. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 32bit / 64bit
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 following message Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production Please observe that the above message is not telling whether it is 32 or 64. But for 64 bit, the message specifically tells you. Thanks, Rao -Original Message- Sent: Tuesday, July 17, 2001 3:38 PM To: Multiple recipients of list ORACLE-L 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 which recompiles all PL/SQL modules and alters certain dictionary tables. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 32bit / 64bit
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: Multiple recipients of list ORACLE-L 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- Sent: Tuesday, July 17, 2001 3:38 PM To: Multiple recipients of list ORACLE-L 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 which recompiles all PL/SQL modules and alters certain dictionary tables. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 32bit / 64bit
The SQL*Plus banner will display if using 64bit. If it does not say '64bit' then it's 32bit. Here is what I get with 9.0.1 64-bit on HP-UX: Connected to: Oracle9i Enterprise Edition Release 9.0.1.0.0 - 64bit Production With the Partitioning option JServer Release 9.0.1.0.0 - Production I do not have 8.1.x in 64-bit but I think the same thing would be true there as well. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Mitchell [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, July 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. > 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 which recompiles all PL/SQL modules and > alters certain dictionary tables. > > > Mitchell > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mitchell > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 32bit / 64bit
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- Sent: Tuesday, July 17, 2001 3:38 PM To: Multiple recipients of list ORACLE-L 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 which recompiles all PL/SQL modules and alters certain dictionary tables. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 32bit to 64bit or vice-a-versa, then you also need to run UTLIRP.SQL script which recompiles all PL/SQL modules and alters certain dictionary tables. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mitchell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
