Abstract
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 tape, and finally one wraps up the gift and places the label. It would help in two aspects: first, if more than one person does the entire work, that person is not bored doing all the gifts all alone; second, when more people help in the process, the work will get done quicker. As the family network expands and more gifts have to be given in a subsequent year, this would mean increasing the number of people to complete the work sooner.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Notes
- 1.
Modified version of the SQL script found on Metalink Note #202219.1.
- 2.
“Parallel Execution Fundamentals in Oracle Database 11g Release 2,” an Oracle White Paper, November 2009.
- 3.
“Parallel Execution Fundamentals in Oracle Database 11g Release 2,” an Oracle White Paper, November 2009.
- 4.
Lewis, Jonathan. “Buffer Sorts.” http://jonathanlewis.wordpress.com/2006/12/17/buffer-sorts/.
- 5.
Ibid.
- 6.
Underscore parameters are hidden parameters and should be modified only with prior guidance from Oracle support.
- 7.
Metalink Note # 1269321.1.
- 8.
Wait events in this section are limited to parallel operations; RAC-specific wait events are discussed in Chapter 17.
- 9.
Metalink Note # 271767.1.
- 10.
Metalink Note # 250947.1.
- 11.
Metalink Note # 250960.1.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2014 Murali Vallath
About this chapter
Cite this chapter
Vallath, M. (2014). Parallel Query Tuning. In: Expert Oracle RAC Performance Diagnostics and Tuning. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-6710-2_8
Download citation
DOI: https://doi.org/10.1007/978-1-4302-6710-2_8
Published:
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-6709-6
Online ISBN: 978-1-4302-6710-2
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books