Abstract
Exadata doesn’t have a special way of executing parallel operations that is not available on other platforms running 11gR2. However, parallel processing is a key component of Exadata because efficient handling of Data Warehouse workloads was a primary design goal for Exadata. In addition, because Offloading/Smart Scan depends on direct path reads, which are used by parallel query slaves, parallel operations take on a whole new importance. Traditionally, the use of parallel query has required careful control of concurrency in order to maximize the use of available resources without overwhelming the system. Oracle’s previous attempts at throttling parallel operations to allow them to be used in multiuser environments have not been entirely successful. 11gR2 provides some new capabilities for controlling parallel operations. In particular, a queuing mechanism has been introduced that allows the number of concurrent parallel processes to be managed more effectively. This approach appears to be much better suited to allowing a high degree of parallelism without overwhelming the available resources than previous attempts. 11gR2 also introduced the ability for Oracle to automatically calculate a degree of parallelism on a statement-by-statement basis.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2011 Kerry Osborne, Randy Johnson, Tanel Pöder
About this chapter
Cite this chapter
Osborne, K., Johnson, R., Pöder, T. (2011). Exadata Parallel Operations. In: Expert Oracle Exadata. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3393-0_6
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3393-0_6
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3392-3
Online ISBN: 978-1-4302-3393-0
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books