2013 | OriginalPaper | Buchkapitel
Adaptive Cursor Sharing
verfasst von : Stelios Charalambides
Erschienen in: Oracle SQL Tuning with Oracle SQLTXPLAIN
Verlag: Apress
Aktivieren Sie unsere intelligente Suche, um passende Fachinhalte oder Patente zu finden.
Wählen Sie Textabschnitte aus um mit Künstlicher Intelligenz passenden Patente zu finden. powered by
Markieren Sie Textabschnitte, um KI-gestützt weitere passende Inhalte zu finden. 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.