CHAPTER
10
Using PL/SQL to Enhance Performance (Developer and DBA)
As with each release before it, Oracle Database 12c continues to elevate PL/SQL performance and functionality to new levels. This chapter focuses on helpful tips that are new with 12c (up to 12cR2) 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 all PL/SQL requests and passes the statements on to Oracle for execution. When PL/SQL is ...
Get Oracle Database 12c 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.
