Preparing applications for migration to Oracle 11G from Oracle 10G
This post will guide you through few hidden facts involved in doing migration from Oracle 10G to Oracle - 11.2.0.4 . Oracle has made significant changes related to performance improvement in 11G release.However, there is no change from perspective of SQL constructs i.e. the effect of SQL queries is same on Oracle 11G. The best way to know about new changes in any Oracle release is to follow its "Companion document" . For Oracle 11G migration, the companion document can be found here . So at a high level, steps for preparing your applications ready for migration are - Read the Companion document and know what new changes are there in the release. If you find any change that could probably impacts the application (i.e. either SQL construct change or a performance change) in Step-1 above, then identify if you can take any of following measures - Do nothing ( Sometimes, even if there is a change in release it doesn't impacts the application behavior. This can be c...