Skip to main content
  • 554 Accesses

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 54.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 69.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Notes

  1. 1.

    Modified version of the SQL script found on Metalink Note #202219.1.

  2. 2.

    “Parallel Execution Fundamentals in Oracle Database 11g Release 2,” an Oracle White Paper, November 2009.

  3. 3.

    “Parallel Execution Fundamentals in Oracle Database 11g Release 2,” an Oracle White Paper, November 2009.

  4. 4.

    Lewis, Jonathan. “Buffer Sorts.” http://jonathanlewis.wordpress.com/2006/12/17/buffer-sorts/.

  5. 5.

    Ibid.

  6. 6.

    Underscore parameters are hidden parameters and should be modified only with prior guidance from Oracle support.

  7. 7.

    Metalink Note # 1269321.1.

  8. 8.

    Wait events in this section are limited to parallel operations; RAC-specific wait events are discussed in Chapter 17.

  9. 9.

    Metalink Note # 271767.1.

  10. 10.

    Metalink Note # 250947.1.

  11. 11.

    Metalink Note # 250960.1.

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints 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

Publish with us

Policies and ethics