Abstract
By this stage in the book you have learned about the underlying architecture of the Oracle database, as well as how you go about creating and manipulating your own data within it. You might well have begun to create your own queries, and thought about applications where you might be able to use them. In Chapter 6, we looked at how Oracle helps you optimize your queries through the use of the Rule-and Cost-based optimizers. However, the optimizers can only suggest execution plans (in the case of the Cost-based optimizer on the basis of its own statistics), rather than optimize their actual execution. This is where tuning comes into play.
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
© 2002 Apress
About this chapter
Cite this chapter
Dillon, S., Beck, C., Kyte, T., Kallman, J., Rogers, H. (2002). Tuning Tools. In: Beginning Oracle Programming. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-5370-9_19
Download citation
DOI: https://doi.org/10.1007/978-1-4302-5370-9_19
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-59059-286-1
Online ISBN: 978-1-4302-5370-9
eBook Packages: Springer Book Archive