Abstract
The aim of this chapter is twofold. First, to avoid unnecessary confusion, I'll introduce some terms that are used repeatedly throughout this book. The most important include selectivity and cardinality, soft and hard parses, and bind variable peeking and extended cursor sharing. Second. I'll describe the life cycle of SQL statements. In other words, I'll describe the operations carried out in order to execute SQL statements. During this discussion, special attention will be given to parsing.
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
© 2008 Christian Antognini
About this chapter
Cite this chapter
(2008). Key Concepts. In: Troubleshooting Oracle Performance. Apress. https://doi.org/10.1007/978-1-4302-0498-5_2
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0498-5_2
Publisher Name: Apress
Print ISBN: 978-1-59059-917-4
Online ISBN: 978-1-4302-0498-5
eBook Packages: Professional and Applied ComputingProfessional and Applied Computing (R0)Apress Access Books