Chapter 8. High Performance PL/SQL
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
Native compilation
We use the following table for most of the examples in this chapter:
-- Available online as part of seed_data.sql CREATE TABLE person ( PERSON_ID NUMBER(10), FIRST_NAME VARCHAR2(20 CHAR), LAST_NAME VARCHAR2(20 CHAR), AGE NUMBER(10), GENDER VARCHAR2(1 ...Get Expert Oracle PL/SQL 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.
