This content has been marked as final. Show 6 replies
Pl identify exact versions of "9i" and "11g" - there are plenty of changes between these versions. You will need to perform test upgrades and test all of your application/functionality to identify issues and their resolution.1 person found this helpful
I would recommend you read thru this document
Oracle 11gR2 Upgrade Companion [ID 785351.1]
1 person found this helpful
925967 wrote:When all else fails Read The Fine Manual
Hello - We are planning to upgrade from 9i to 11g, Is there somewhere documented how the optimizer behaves and also any code changes that we can recommend to be changed for developers. It would be great for any suggestions.
http://www.oracle.com/technetwork/database/focus-areas/manageability/owp-spa-9i-10g-128292.pdf1 person found this helpful
Hello Srini - Here is the version 188.8.131.52 and the 11g version would be 184.108.40.206.. and thanks for the reply, i will go thru the doc.
Thanks for reply Dom, going through the documents. Thanks for help. DO we have any known problems on batch jobs after upgrade that we usually encounter or any code changes that require from application side?
Hard to say - most, if not all, of the code should work as it does in 9i. Only thorough testing in a test environment will reveal what continues to work and what code will require changes or tweaking.