August 2014
Intermediate to advanced
336 pages
7h 58m
English

One of the most important optimization strategies is to make sure that you are not performing the same operations multiple times. But often this is difficult to avoid. In those cases, the best option is to minimize the impact by trying to cache already calculated results. Currently, Oracle supports different caching mechanisms, each with its own strengths, drawbacks, and side effects. This chapter will introduce you to all PL/SQL-related mechanisms and describe the selection criteria for when each should be utilized.
For years, Oracle has tried to ensure that the database engine works as little ...