This content has been marked as final. Show 3 replies
Pl post exact version of "11g". Check the links in this thread - Reg : Difference(s) between Oracle versions --
For the most part, all of your 10g code should work as is in 11g - it is best to perform a test upgrade and test your application to verify.
If you want to antecipate future problems (totally agree), I would suggest you use the Real Application Testing (RAT) features: Database Replay and SQL Performance Analyzer (SPA) .
That would tell you exactly what you performance problems may be.
How to Shrink the datafile of Undo Tablespace [ID 268870.1] Real Application Testing Now Available for Earlier Releases [ID 560977.1]
Check out the docs:
This is in the upgrade guide for 11.1, check it out for each version of docs between the DB version you are going from and to. For you it will be the 11.1 docs above and the 11.2 docs. Look at the behaviour changes.