This article discusses a new Oracle Database 11gR1 feature - Adaptive Cursor Sharing - and illustrates how to use it in practical situations to limit hard parsing of SQL statements with bind variables while increasing the relative execution efficiency of those statements.

This story continues at
http://www.dbasupport.com/oracle/ora...haring01.shtml