RE: adaptive cursor sharing and bind peeking
From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Fri, 31 May 2013 07:05:51 +0000
Message-ID: <43D812FCDBAB8948B2F14F61C4B1CD0A5AFEA001_at_smxc002.trivadis.com>
Hi Carlos
Date: Fri, 31 May 2013 07:05:51 +0000
Message-ID: <43D812FCDBAB8948B2F14F61C4B1CD0A5AFEA001_at_smxc002.trivadis.com>
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.
HTH
Chris Antognini
Troubleshooting Oracle Performance, Apress 2008 http://top.antognini.ch
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 31 2013 - 09:05:51 CEST