2013 | OriginalPaper | Chapter
Adaptive Cursor Sharing
Author : Stelios Charalambides
Published in: Oracle SQL Tuning with Oracle SQLTXPLAIN
Publisher: Apress
Activate our intelligent search to find suitable subject content or patents.
Select sections of text to find matching patents with Artificial Intelligence. powered by
Select sections of text to find additional relevant content using AI-assisted search. powered by
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.