upgrade from 9.2.0.8 to 11.1.0.7
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
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
0