O'Reilly logo

Troubleshooting Oracle Performance by Christian Antognini

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

PART 4Optimization

Performance is your reality. Forget everything else.

—Harold Geneen1

Only once you have identified the root cause of a performance problem should you try to solve it. As described in Chapter 3, several kinds of problems exist. Regardless of the problem you are facing, the essential goal to achieve is reducing—or, even better, eliminating—the time spent by the most time-consuming operation. Note that a single operation may be composed of many actions that are executed one by one. For example, many fetches are necessary in order to fully process a query returning a lot of data.

Chapter 8 describes how parsing works, how to identify parsing problems, and how to minimize its impact without jeopardizing performance. Chapter 9

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required