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).