We are planning to upgrade the oracle database from 10.2.0.4.0 to oracle 11g.
Can i know what are the general features and oracle pl/sql features which are supported in 10 are not supported in oracle 11g(obsolete features) and
what are the obsolete features in oracle 11g.
Basically i am the oracle pl/sql developer, how the upgrade would impact the existing code.
Thanks in advance for reply.
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.