Diego, If you have java objects installed then you may add atleast around 1 hour 30 minutes more than normal migration time. I have migrated 7/8 databases from 8.1.7.4 to 9.2.0.X in 1 to 3 hours including recompilation of objects. If you are talking about Oracle Financials database, it depends on much modules you have installed. Just recompilation of invalids might take around 3 to 4 hours depending upon power of your server. Regards Rafiq From: "Diego Cutrone" <diegocutrone@xxxxxxxxxxxx> Reply-To: oracle-l@xxxxxxxxxxxxx To: <oracle-l@xxxxxxxxxxxxx> Subject: Re: Quick migration question Date: Wed, 7 Jul 2004 09:29:52 -0700 Tanel, Thank you very much for the insight, it's been very useful for me. Regards Diego. ----- Original Message ----- From: "Tanel Põder" <tanel.poder.003@xxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Tuesday, July 06, 2004 4:00 PM Subject: Re: Quick migration question > The upgrade speed doesn't really depend on how much actual data you got in > your tables. > The most time-consuming job in an upgrade like this, is the migration of > data dictionary and recompilation of objects. Other changes, like changing > controlfiles, datafile headers, logfiles and rollback segments, will usually > take little time. > > Oracle will NOT go through any datafile to change or reformat any datablocks > during the upgrade (it didn't do so even when the data block format changed > fundamentally between version 7.3 and 8, it just reformatted required blocks > later on, "on the fly"). > > So if you don't have much more objects and PL/SQL in your current system > than the last one upgraded (and don't have tens of thousands of datafiles), > you should be able to complete your upgrade about in the same timeframe than > the last one. > I'd say in less than couple of hours without any tweaks or tricks, given > than you could recompile your PL/SQL & other objects in parallel. > > It's possible to get the upgrade process very fast - but this means > unsupported parameters & techniques. > > Tanel. > > ----- Original Message ----- > From: "Diego Cutrone" <diegocutrone@xxxxxxxxxxxx> > To: "Oracle List" <oracle-l@xxxxxxxxxxxxx> > Sent: Wednesday, July 07, 2004 4:41 AM > Subject: Quick migration question > > > > Hi list, > > Based on your experience, how much time you think it may take to migrate a > 2.1 TB database from 8.1.7 to 9.2 > > by using "startup migrate" procedure. The database is in a HP Superdome > with 16CPUs 64GB Ram. > > I know the time depends on many other factors but I'd just like to have a > rough estimation....that's all. > > > > I have used this procedure in a much smaller database and didn't take a > long time to complete, > > I wonder how much it will take in a much bigger database. Had anyone > performed a migration like this? > > > > Thanks in advance. > > Regards > > Diego. > > ---------------------------------------------------------------- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > ---------------------------------------------------------------- > > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > > put 'unsubscribe' in the subject line. > > -- > > Archives are at //www.freelists.org/archives/oracle-l/ > > FAQ is at //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@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------