O'Reilly logo

Expert Oracle PL/SQL by Michael McLaughlin, Ron Hardman

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

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

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