CHAPTER10
Optimizing Using PL/SQL
Purpose
The purpose of this chapter is to introduce you to performance tuning concepts using PL/SQL as a statistics-gathering platform. Within an Oracle database there are many objects that provide differing levels of information which, if gathered and properly analyzed, can help to optimize areas such as indexing, data modeling, table structure, and SQL statements. For example, when using dbms_scheduler, as shown in Chapter 9, maintenance tasks become less frequent, or even better automated, and available database resources are more fully utilized through parallelizing dbms_scheduler jobs.
To help you better ...
Get Oracle Database 12c PL/SQL Advanced Programming 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.
