O'Reilly logo

Oracle Database 11g Release 2 Performance Tuning Tips & Techniques by Richard Niemiec

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image
CHAPTER
10
Using PL/SQL to Enhance Performance (Developer and DBA)
image
As with each release before it, Oracle 11g continues to elevate PL/SQL performance and functionality to new levels. This chapter focuses on helpful tips that are new with 11g (up to 11gR2) as well as tips that continue to be useful from older versions. Once you have great queries to monitor your system, you need to automate them. PL/SQL gives you the capability to do so while also providing some great packages and procedures that you can use for tuning. The PL/SQL engine processes ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required