Hi Experts,
I am starting with migration of Oracle database from 10.2.0.4.0 to 11.2.0.4.0. Need some advice in this regard...
From the setup/installation of binaries/setting of parameters/etc. point-of-view, it will be taken care by DBAs. But, I will take care of the functionality and behavior of application post migration. So, I am trying to come up with a plan for this.
Fyi - We have a front-end Java application, which executes either direct queries or through views, and displays the data.
I have made a list of SQL/PLSQL new features introduced, and will try to implement, wherever feasible.
Also, was going through this post and got some pointers what possible issues might be encountered during this.
Concerns -
1) After the migration, when the front-end application will be accessed by user for the first-time, it might take long time to load the pages because the Shared Pool (SQL) and Buffer Cache (data) has to be loaded first.
Is this understanding correct ? If yes, how to avoid it ?
2) When the entire schema dump is moved from 10g to 11g server, does it require stats gathering for the tables and indexes ?
3) What other things should be taken care and considered while planning this ?
This is for the first time I am part of a database migration project . Please advise...
Thanks and Regards,
-Ranit