Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Migration Assistant Speeds

Re: Migration Assistant Speeds

From: Mohammad Rafiq <rafiq9857_at_hotmail.com>
Date: Wed, 11 Sep 2002 12:52:35 -0400
Message-Id: <22541.293574@fatcity.com>


Keep in mind that the actual change to DB internal header blocks does not occur until they are actually read into the DB. Therefore I launched an ANALYZE to build statistics which ran 12 - 14 hours.

Regards
Rafiq

From: Charlie_Mengler_at_HomeDepot.com
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: Re: Migration Assistant Speeds
Date: Wed, 11 Sep 2002 09:24:46 -0800

I did a 150GB V7.3.4.5 upgrade to V9.2 in less than 2 hours.

Keep in mind that the actual change to DB internal header blocks does not occur until they are actually read into the DB. Therefore I launched an ANALYZE to build statistics which ran 12 - 14 hours.

THT & YMMV!

                       "Post, Ethan"
                       <Ethan.Post_at_ps.ne        To:       Multiple 
recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
                       t>                       cc:
                       Sent by:                 Subject:  Migration 
Assistant Speeds
                       root_at_fatcity.com


                       09/11/2002 09:23
                       AM
                       Please respond to
                       ORACLE-L






Can anyone share experience with running database migration assistant against a 150 GB database (7.3.4) and how long it takes? Don't have the box
specs yet but I think it is a 3 CPU HPUX with 2 GB Ram and a couple of unmirrored disks.
--

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

Author: Post, Ethan

   INET: Ethan.Post_at_ps.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

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

--

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

Author:

   INET: Charlie_Mengler_at_HomeDepot.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists

--------------------------------------------------------------------
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 Wed Sep 11 2002 - 11:52:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US