Summary

In this chapter, we learned the effect of compilation settings on the application performance. We understood the difference between interpreted/native compilation modes and learned the real native compilation feature introduced in Oracle 11g. We covered the PL/SQL tuning recommendations supported with demonstrations. Towards the end, we saw the effect of the optimization level on code execution through illustrations, intra unit inlining feature, and usage of PRAGMA INLINE in programs to explicitly inline subprogram calls.

In the next chapter, we will cover one of the most talked about features of Oracle 11g. The feature is known as result caching which promises tremendous performance gains in database applications.