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.
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
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 subscriptionsPreview
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