O'Reilly logo

Troubleshooting Oracle Performance, Second Edition by Christian Antognini

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 2

image

Key Concepts

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.

Selectivity and Cardinality

The selectivity is a value between ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required