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
To help you better ...