Re: 32 or 64?

[Mogens N�rgaard]

Yep. If you benefit from using more memory than what 32 bit stuff can 
handle, then of course 64 bit will help. If you don't benefit from more 
memory (that's likely to be the case for most), then 64 will just add 
overhead. But if the vendors are pushing 64 bit, then management will 
buy it. It has to be better, since the number is bigger (Law Of Bigger 
Numbers - LOBN). One could speculate that the next version of Oracle 
might only be available on 64 bit platforms, except of course on Intel.

Mogens

PS: And Anjo will do a presentation about this 64 bit stuff at the 
Database Forum here RSN.

Karniotis, Stephen wrote:

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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
 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).