Abstract
Perhaps the most complex problem in database administration is SQL tuning, and it may not be a coincidence that I left it for the very end. The paucity of books devoted to SQL tuning is perhaps further evidence of the difficulty of the topic.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsNotes
- 1.
In Oracle on VMware, Dr. Bert Scalzo makes a persuasive case for “solving” problems with hardware upgrades: “Person hours cost so much more now than computer hardware even with inexpensive offshore outsourcing. It is now considered a sound business decision these days to throw cheap hardware at problems”.
- 2.
Don Burleson, “Optimizing Oracle Optimizer Statistics,” Oracle FAQ’s, March 1, 2004, www.orafaq.com/node/9 .
- 3.
Mogens Norgaard in the Journal of the Northern California Oracle Users Group.
- 4.
Dave Ensor as remembered by Mogens Norgaard and quoted in the Journal of the Northern California Oracle Users Group.
- 5.
Mogens Norgaard in the Journal of the Northern California Oracle Users Group.
- 6.
Wolfgang Breitling in the Journal of the Northern California Oracle Users Group.
- 7.
Jonathan Lewis in the Journal of Northern California Oracle Users Group.
- 8.
The use of hints is a defense against bind variable peeking. To understand the problem, remember that a query-execution plan is constructed once and used many times. If the values of the bind variables in the first invocation of the query are not particularly representative of the data, the query plan that is generated will not be a good candidate for reuse. Stored outlines are another defense against bind variable peeking. It is also possible to turn off bind variable peeking for your session or for the entire database; this forces Oracle to generate a query plan that is not tailored to one set of bind variables. However, note that bind variable peeking does work well when the data has a uniform distribution.
Author information
Authors and Affiliations
Rights and permissions
Copyright information
© 2015 Ignatius Fernandez
About this chapter
Cite this chapter
Fernandez, I. (2015). SQL Tuning. In: Beginning Oracle Database 12c Administration. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0193-0_17
Download citation
DOI: https://doi.org/10.1007/978-1-4842-0193-0_17
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-4842-0194-7
Online ISBN: 978-1-4842-0193-0
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books