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"                                                    
                                          
                      <[EMAIL PROTECTED]        To:       Multiple recipients of list 
ORACLE-L <[EMAIL PROTECTED]>             
                      t>                       cc:                                     
                                          
                      Sent by:                 Subject:  Migration Assistant Speeds    
                                          
                      [EMAIL PROTECTED]                                                 
                                          
                                                                                       
                                          
                                                                                       
                                          
                      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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to