From oracle-l-bounce@freelists.org Tue Apr 27 16:26:50 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3RLQZO02507 for ; Tue, 27 Apr 2004 16:26:45 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i3RLQO602455 for ; Tue, 27 Apr 2004 16:26:34 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7939A72E56E; Tue, 27 Apr 2004 16:17:09 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 03256-18; Tue, 27 Apr 2004 16:17:09 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BEAFE72E58E; Tue, 27 Apr 2004 16:17:08 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 27 Apr 2004 16:15:54 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B1A0672E0D8 for ; Tue, 27 Apr 2004 16:15:53 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02953-10 for ; Tue, 27 Apr 2004 16:15:53 -0500 (EST) Received: from web13422.mail.yahoo.com (web13422.mail.yahoo.com [216.136.175.132]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id EFC9872E07C for ; Tue, 27 Apr 2004 16:15:52 -0500 (EST) Message-ID: <20040427212828.22694.qmail@web13422.mail.yahoo.com> Received: from [199.79.222.123] by web13422.mail.yahoo.com via HTTP; Tue, 27 Apr 2004 14:28:28 PDT Date: Tue, 27 Apr 2004 14:28:28 -0700 (PDT) From: Peter Barnett Subject: RE: 32 bit/64 bit datafile? To: oracle-l@freelists.org In-Reply-To: <91E3FFBB780D6945B8A5D90569A74461CA2F1F@bobwpmsg001.choicepoint.net> MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 3888 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: regdba@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org If you are running AIX, a patch is required but it is essentialy an upgraded version of rootpre.sh that is run independently. --- Ken Payton wrote: > The difference between 32bit and 64bit is the memory > structures, ie. it = > allows a larger than 4GB SGA. The bit version of > the database does not = > modify the blocksize or datafile structures that I > am aware of. In fact = > I believe you can move your database from 32bit to > 64bit with few = > changes. I believe it is as simple as changing your > ORACLE_HOME to the = > 64bit tree(assuming you have already installed it), > runing the catalog = > scripts and recompile all pl/sql. No data > conversions are necessary. =20 > > Kenny Payton > ChoicepointPRG > Sr. Database Administrator > > -----Original Message----- > From: oracle-l-bounce@freelists.org > [mailto:oracle-l-bounce@freelists.org]On Behalf Of > jtesta@dmc-it.com > Sent: Monday, April 26, 2004 4:02 PM > To: oracle-l@freelists.org > Subject: 32 bit/64 bit datafile? > > > I know this was discussed in years gone by but I > can't find the saved = > info: > > A database was "upgraded" (changed word size) from > 32 -> 64 bit. > > Without rebuilding the tablespaces/datafiles, my > understanding is you > don't gain much in the performance arena. > > Will a dump of a datafile header prove that it was > originally created = > w/32 > bit oracle? > > thanks, joe > > > > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: > oracle-l-request@freelists.org > put 'unsubscribe' in the subject line. > -- > Archives are at > http://www.freelists.org/archives/oracle-l/ > FAQ is at > http://www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: > oracle-l-request@freelists.org > put 'unsubscribe' in the subject line. > -- > Archives are at > http://www.freelists.org/archives/oracle-l/ > FAQ is at > http://www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- ===== Pete Barnett Lead Database Administrator The Regence Group pnbarne@regence.com __________________________________ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------