O'Reilly logo

Expert PL/SQL Practices for Oracle Developers and DBAs by Riyaj Shamsudeen, Robyn Sands, Michael Rosenblum, Stephan Petit, Arup Nanda, Connor McDonald, Torben Holm, Sue Harper, Dominic Delmolino, Lewis Cunningham, Ron Crisco, Melanie Caffrey, Martin Büchi, Adrian Billington, John Beresniewicz

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

C H A P T E R  13

Profiling for Performance

by Ron Crisco

Performance and profiling are critical words in our everyday conversations in the office where I work, in our engagements with clients, and in our teaching. Both words apply equally well to all aspects of life, including software engineering and the topic at hand, PL/SQL.

I first encountered PL/SQL at its inception in the beta release of SQL*Forms 3, Oracle's character-based interactive application development tool. Over the years, I have learned much about writing high performance PL/SQL code, and I am excited to share what I have learned with you.

What exactly does performance mean in the context of PL/SQL? By the end of this chapter, my goal is to arm you with the knowledge and understanding ...

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