Tuning is a task that relies on an understanding of both code and database design. As a result, it can be one of the most difficult tasks for a developer or DBA to undertake. It can also be one of the most enjoyable and lucrative specialties. In this chapter, we focus on PL/SQL performance. In particular, the following topics are covered:
Changes to Oracle 10g that impact performance
SQL tuning techniques
Ways to collect performance information for PL/SQL
We use the following table for most of the examples in this chapter:
-- Available online as part of seed_data.sqlCREATE TABLE person ( PERSON_ID NUMBER(10), FIRST_NAME VARCHAR2(20 CHAR), LAST_NAME VARCHAR2(20 CHAR), AGE NUMBER(10), GENDER VARCHAR2(1 ...