Key Concepts

  • Christian Antognini


The aim of this chapter is threefold. First, to avoid unnecessary confusion, I introduce some terms that are used repeatedly throughout this book. The most important include selectivity and cardinality, cursor, soft and hard parses, bind variable peeking , and adaptive cursor sharing. Second, I describe the life cycle of SQL statements. In other words, I describe the operations carried out in order to execute SQL statements. During this discussion, special attention is given to parsing. And third, I describe how to instrument application code and database calls.


Execution Environment Execution Plan Query Optimizer Bind Variable Database Engine 

Copyright information

© Christian Antognini 2014

Authors and Affiliations

  • Christian Antognini
    • 1
  1. 1.Monte CarassoSwitzerland

Personalised recommendations