O'Reilly logo

Oracle Database 12c PL/SQL Advanced Programming Techniques by John Harper, Michael McLaughlin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

image

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required