Database Administration (MOSC)

MOSC Banner

upgrade from 9.2.0.8 to 11.1.0.7

edited Jul 20, 2009 3:53PM in Database Administration (MOSC) 7 commentsAnswered
Hi All I have to estimate duration of upgrade from 9i to 11g. I used manual upgrade on test environment with smaler database . It take 40 min.
I think that duration of upgrade depend on datadictionary not on size of db , it means not on size of application data, and not on amount of datafiles (may by only some write to header of datafile if is online )
I think :
estimate_time= time_to_upgrade(size_of_data_dictionary*0.9) + time_to_upgrade(amount_of_datafiles*0.1)
this means :
- when upgrade of my test db takes 40min  ( cca 10G) and production db has same number of datafiles but size of db is 500G duration depend on size of dictionary

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center