Skip to Main Content
Oracle PL/SQL Performance Tuning Tips & Techniques
book

Oracle PL/SQL Performance Tuning Tips & Techniques

by Michael Rosenblum, Paul Dorsey
August 2014
Intermediate to advanced content levelIntermediate to advanced
336 pages
7h 58m
English
McGraw Hill Computing
Content preview from Oracle PL/SQL Performance Tuning Tips & Techniques

Image

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL Best Practices

Oracle PL/SQL Best Practices

Steven Feuerstein
Oracle PL/SQL for DBAs

Oracle PL/SQL for DBAs

Arup Nanda, Steven Feuerstein

Publisher Resources

ISBN: 9780071824828