Re: Migration Assistant Speeds

From: Ron Thomas <rthomas_at_hypercom.com>
Date: Wed, 11 Sep 2002 10:53:58 -0700
Message-Id: <22541.293578@fatcity.com>

Also keep in mind that if you use the assistant to go from 7.x to 8.x, the system tablespace will grow at least 2x. During the migration process, both the 7.x and 8.x data dictionary exists. For our Oracle Applications 10.7 instances with 55,000 objects, this was not acceptable. We instead exported/imported. This also gave us the apportunity to move to LMTs.

Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
If A = B and B = C, then A = C, except where void or prohibited by law. -- Roy Santoro

                                                                                                                                      
                      root_at_fatcity.com                                                                                                
                                               To:       ORACLE-L_at_fatcity.com                                                         
                      09/11/02 10:53 AM        cc:                                                                                    
                      Please respond to        Subject:  Re: Migration Assistant Speeds                                               
                      ORACLE-L

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.

I shall go for full export with direct=y recordlength-65535 and file=/dev/null which may be much faster then analyze....may be 5-6 hours .....

Regards
Rafiq

Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 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

Send and receive Hotmail on your mobile device: http://mobile.msn.com

--

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

Author: Mohammad Rafiq
INET: rafiq9857_at_hotmail.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