Abstract
Parallelism can help improve performance on particular operations simply by assigning multiple resources to a task. Parallelism is best used on systems with multiple CPUs, as the multiple processes used (that is, the parallel processes) will use those extra CPU resources to more quickly complete a given task.
This is a preview of subscription content, log in via an institution to check access.
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 Sam R. Alapati, Darl Kuhn, and Bill Padfield
About this chapter
Cite this chapter
Alapati, S.R., Kuhn, D., Padfield, B. (2011). Executing SQL in Parallel. In: Oracle Database 11g Performance Tuning Recipes. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-3663-4_15
Download citation
DOI: https://doi.org/10.1007/978-1-4302-3663-4_15
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4302-3662-7
Online ISBN: 978-1-4302-3663-4
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books