CHAPTER 8

image

Parallel Query Tuning

A good analogy for parallel processing is to take an example from our everyday life. It’s that time of the year: the holidays when people are anxiously waiting to exchange gifts. Several people need to be given gifts and to get the gifts ready, the package needs to be packed, glued, and labeled. Once finished it’s either delivered in person or delivered to the post office for shipping. What if there was a method to break this entire processing into smaller pieces of work where a different person does each piece of work? One person cuts the paper, another assembles the gifts for one recipient, another cuts the adhesive ...

Get Expert Oracle RAC Performance Diagnostics and Tuning 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.