O'Reilly logo

Oracle SQL Tuning with Oracle SQLTXPLAIN by Stelios Charalambides

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 7

image

Adaptive Cursor Sharing

There’s no doubt that Adaptive Cursor Sharing is one of the most misunderstood and confusing optimizer areas. It doesn’t help that it is sometimes referred to as Intelligent Cursor Sharing or Bind Aware Peeking. Adaptive Cursor Sharing was introduced in 11g to take care of those pesky bind variables that keep changing. SQLTXTRACT has a section called “Cursor Sharing and Binds,” which can be found at the top of the main report. See Figure 7-1 to remind yourself. The Adaptive Cursor Sharing section is at the bottom left of the screen.

Figure 7-1 .  The Adaptive Cursor Sharing section can be found in the bottom ...

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