Introduction to Adaptive Cursor Sharing Concepts and Multimedia Demo [Video] (文档 ID 1115994.1)-优快云博客

本文介绍了Oracle 11g中引入的Adaptive Cursor Sharing特性，通过视频教程展示了该功能如何改进使用绑定变量的查询计划，并通过一个具有倾斜数据的表实例演示了在不同直值下选择最优计划的过程。

In this Document
 
 Goal
 Fix
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
 APPLIES TO: Oracle Server - Enterprise Edition - Version 11.2.0.1.0 to 11.2.0.3 [Release 11.2]
 
 Information in this document applies to any platform.
 
 Affected Database: Oracle
 
 Checked for relevancy 25th June 2012
 


 GOALAdaptive Cursor Sharing feature is introduced with Oracle 11g.  This new feature improves the CBO plans for queries that use  bind variables.
 
 FIX Video - Adaptive Cursor Sharing Concepts and Demo 11g (09:47) 
 
Topics : Adaptive Cursor Sharing
 
 [1]  Overview 
 [2] Architecture
 [3] Views
 [4] Interacting with ACS : Demo
       The demo shows a table that has skewed data. It uses histograms and the optimizer choose the 
       optimal plan for different literal values using adaptive cursor sharing.
      

   
            附件 
          
    Adaptive Cursor Sharing Concepts and Demo 11g(4.42 MB)

   
            相关内容 
          
              产品 
            
       Oracle Database Products > Oracle Database > Oracle Database > Oracle Database - Enterprise Edition > RDBMS > Generic SQL Performance, SQL Execution, Query Optimizer
 
              关键字 
            
     ADAPTIVE CURSOR SHARING;
     
     CURSOR SHARING