This content has been marked as final. Show 3 replies
Pl post OS details.
For your RMAN question, pl ask in the RMAN forum - Recovery Manager (RMAN)
Most 10.2.0.4 SQL code will run faster on 11gR2 - this can only be validated by thorough testing.
Pl see these MOS Docs
Query Performance Degradation - Upgrade Related - Recommended Actions [ID 745216.1]
Using SQL Performance Analyzer to Test SQL Performance Impact of an Upgrade [ID 562899.1]
Things to Consider Before Upgrading to 18.104.22.168 to Avoid Poor Performance or Wrong Results [ID 1392633.1]
You can also use Database Replay “Real application testing” for a better testing of your production workload.
Inevitably you'll have to test your PL/SQL code in 11gR2 before to upgrade producction