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.
KeywordsServer Process Execution Environment Execution Plan Query Optimizer Bind Variable
Unable to display preview. Download preview PDF.