This content has been marked as final. Show 3 replies
Check for some help in this document:1 person found this helpful
Pl identify exact version of "11g" and your OS. Only appropriate testing of your application will reveal any issues at your particular site
TROUBLESHOOTING: Server Upgrade Results in Slow Query Performance [ID 160089.1]
Query Performance Degradation - Upgrade Related - Recommended Actions [ID 745216.1]
I would add to this that I found a new [url http://www.ora00600.com/scripts/11g/10g-to-11g-upgrade.html]default 11g resource manager plan which is enabled by default. We didn't find out until after we had rolled to PROD, so have a read of that link.
There are tools available for testing your SQL performance on the new system, such as Real Application Testing and SQL Performance Analyzer (SPA). The former is a pretty big challenge to get it working properly from my experience with it for an 10g to 11g upgrade. I'd go with the SPA and see what it turns up.