Summary
In this chapter, we have discussed the features that can tune your PL/SQL code to run faster. We have also seen how code compilation and optimization can speed up the performance of the PL/SQL programs. In the later half, we discussed the PL/SQL tuning features in detail with the help of demonstrations.
In the next chapter, we will focus on one of the major new features introduced in Oracle Database 11g. The feature is known as result caching that is primarily built to accelerate the performance of queries that are repeatedly executed. We will discuss the different flavors of result caching in the next chapter.
Get Advanced Oracle PL/SQL Developer's Guide - Second Edition 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.
