April 2017
Intermediate to advanced
436 pages
12h 7m
English
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 9-1 to remind yourself. The Adaptive Cursor Sharing section is at the bottom left of the screen.
