Using PL/SQL to Enhance Performance (Developer and DBA)
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 ...