Oracle-L: Re: Performance consequences from downgrading from 64-bit to 32-bit?

From: chao_ping <chao_ping_at_vip.163.com>
Date: Fri, 15 Nov 2002 09:24:04 -0800
Message-ID: <F001.0050475F.20021115092404@fatcity.com>

Thomas Jeff£¬ÄúºÃ£¡

       The main problem i think is that 32bit oracle has its sga size limit, if i remember it correctly, it is only 1.75GB, which is not big enough for oracle running on S80?
		Maybe you can relink it to enlarge sga, i ever see document about enlarge sga via relink on solaris ,but not on aix.
		To move the server, i think install oracle on the new node and copy datafile and run $ORACLE_HOME/rdbms/admin/utlrp.sql should work.
		Good luck

¡¡¡¡

2002-11-15 08:59:00 ÄúÔÚÀ´ÐÅÖÐÐ´µÀ£º ========

We have an 8.1.7.4 64-bit 24x7 OLTP database currently hosted on an RS6000 s80 running AIX 4.3.3 The database is scheduled to be migrated to a new box, RS6000 ip680, running AIX 5.1. According to the compatibility matrix on Metalink, 64-bit 8.1.7.4 is not certified on AIX 5.1, but the 32-bit version is. So one option is to simply downgrade to 8.1.7.4 32-bit when we make the move. Would we expect to see any performance degradation as a result of moving from 64-bit to 32-bit, notwithstanding the fact the degradation could be masked by virtue of moving to a newer, faster box?
Thanks.

Jeffery D Thomas
DBA
Thomson Information Services
Thomson, Inc.
Email: jeff.thomas_at_thomson.net
Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba
Select 'Indy DBA' then 'DBA Web Pages'

= = = = = = = = = = = = = = = = = = = = = ¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡ÖÂ Àñ£¡

¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡chao_ping
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡chao_ping_at_vip.163.com
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡2002-11-16

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: chao_ping
INET: chao_ping_at_vip.163.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). Received on Fri Nov 15 2002 - 11:24:04 CST