The added benefit comes with technology's ability to address/reference disk/memory/etc. in the 64-bit address space. Additionally straight 64-bit computing offers some added performance versus the concatenation of two 32-bit words. Tim is correct in that some performance degradation can be experienced if not implemented properly.
Now, several vendors, as Joe Testa indicated, are converting all binaries to 64-bit and will not support 32-bit any longer. HP, Oracle, Sun, etc. are some prime examples. Expect the conversion/migration to take some time as 32-bit apps are still out there and will not be changed for several years. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -----Original Message----- Sent: Monday, August 18, 2003 12:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: 32 or 64? There are no performance benefits from the software change; in fact, anecdotal evidence is that there might even be a hit, since we're now moving more data about (i.e. 64-bit integers instead of 32-bit integers), but that is certainly debatable. Some very simple testing with C programs on dedicated servers should be able to lay that to rest... Bigger SGA and PGA along with access to the latest and greatest (?) software *probably* falls into the category of a benefit, right? The reason it may not be a benefit is that then folks see the ability to add more RAM as an all-round panacea. There's something purifying about having to make do within limitations... Not aware of any specific bugs related to wordsize. By the way, switching between wordsize isn't that hard. Check out the script "?/rdbms/admin/utlirp.sql" and the package UTL_RP and some related MetaLink notes... on 8/18/03 9:14 AM, Daniel Fink at [EMAIL PROTECTED] wrote: > From a technical and business perspective, what are the reasons to migrate > from 32-bit to 64-bit Oracle? Are there known bugs/problems with one version > that are not present in the other? > > Daniel Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
