CHAPTER 10Using PL/SQL to Enhance Performance (Developer and DBA)
Oracle 10g takes PL/SQL to the next level. We'll focus on helpful tips that are new with 10g (up to 10gR2) as well as tips that continue to be useful from older versions in this chapter. Once you have all of the great queries to monitor your system, you need to automate all of them. PL/SQL gives you the ability to do so while also providing some great packages and procedures that can be used for tuning. The PL/SQL engine processes all PL/SQL requests and passes the statements onto Oracle for execution. When PL/SQL is passed to Oracle, it is placed in Oracle's System Global Area (SGA), more particularly in the shared pool. In Oracle, PL/SQL source code can be stored in the database ...
Get Oracle Database 10g 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.