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 ...

Get Oracle Database 11g Release 2 Performance Tuning Tips & Techniques now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.