O'Reilly logo

Oracle Advanced PL/SQL Developer Professional Guide by Saurabh Gupta

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. Compiling and Tuning to Improve Performance

The code compilation philosophy is one of the transparent activities in a programming language which latently influences a program's execution performance. Oracle 11g has introduced the real native compilation to cope with the bitter experiences of native and interpreted compilation techniques. Besides the compiler enhancement, Oracle 11g has introduced a new optimization level which brings terrific improvements in database performance by fueling up the optimizer's intelligence. Furthermore, the intra unit inlining feature applies an optimization level to assure logical gains in PL/SQL code performance by inlining local subprogram invocations in program calls. In this chapter, we will learn ...

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