PLSQL with Oracle 11g

I have quite a few lines of PL/SQL code in Oracle 10g, and we are going to move to 11g. I expect my code to work there too, but:

• Are there any pitfa开发者_如何学JAVAlls to expect, any problems you encountered?
• What new features are you using?

The big new feature for me is the PL/SQL Function Result Cache, for functions that you call over and over again.

We recently upgraded to 11g and had no issues with our previous stored procs. It was a pretty smooth upgrade for us. As is always recommended, upgrade a test environment and do testing of your SPs and database dependent apps to ensure your environment doesn't have any issues.

So far my only issue with 11.1 is that Natively Compiled PL/SQL is running 2-3% slower than Interpreted. Was quite a surprise for us. Supposedly things are working better in 11.2 but haven't had time to mess with it yet.