RE: adaptive cursor sharing and bind peeking

  • From: Christian Antognini <Christian.Antognini@xxxxxxxxxxxx>
  • To: Carlos Sierra <carlos.sierra.usa@xxxxxxxxx>
  • Date: Fri, 31 May 2013 07:05:51 +0000

Hi Carlos

> Once it is bind aware on every execution it looks at the values of binds and 
> compares to acs selectivity profile for this sql

When a cursor is open, its execution plan cannot be changed. As a result, the 
peeking and everything else that goes with it in case of a bind-aware cursor 
can only be done when a parse call is performed. This is also the reason why 
static cursors in PL/SQL loops or Java applications using client-side statement 
caching cannot take advantage of ACS.

Chris Antognini

Troubleshooting Oracle Performance, Apress 2008 


Other related posts: