RE: 32 or 64?

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:	Stephen.Karniotis_at_Compuware.com 
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 Daniel.Fink_at_Sun.COM 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: tim_at_sagelogix.com

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: ListGuru_at_fatcity.com (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: Stephen_Karniotis_at_compuware.com

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: ListGuru_at_fatcity.com (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).