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]