CHAPTER8Keeping the Cache
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.
Built-in Caching Techniques
For years, Oracle has tried to ensure that the database engine works as little ...
Get Oracle PL/SQL Performance Tuning Tips & Techniques 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.
