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 ...
Get Oracle Advanced PL/SQL Developer Professional Guide 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.
