PLSQL 与 Oracle 11g
我在 Oracle 10g 中有相当多行 PL/SQL 代码，我们将迁移到 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 pitfalls to expect, any problems you encountered?
- What new features are you using?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
对我来说最大的新功能是 PL/ SQL 函数结果缓存，用于您一遍又一遍调用的函数。
The big new feature for me is the PL/SQL Function Result Cache, for functions that you call over and over again.
我们最近升级到 11g，之前的存储过程没有出现任何问题。这对我们来说是一次非常顺利的升级。正如始终建议的那样，升级测试环境并对 SP 和数据库相关应用程序进行测试，以确保您的环境没有任何问题。
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.
到目前为止，我对 11.1 的唯一问题是本机编译的 PL/SQL 的运行速度比解释的慢 2-3%。对我们来说是一个很大的惊喜。据说 11.2 中一切都工作得更好，但还没有时间去搞乱它。
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.