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: <Charlie_Mengler_at_HomeDepot.com>
Date: Wed, 11 Sep 2002 09:19:06 -0700
Message-Id: <22541.293567@fatcity.com>


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). Received on Wed Sep 11 2002 - 11:19:06 CDT

Original text of this message

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