RE: adaptive cursor sharing and bind peeking
- From: Christian Antognini <Christian.Antognini@xxxxxxxxxxxx>
- To: "ax.mount@xxxxxxxxx" <ax.mount@xxxxxxxxx>
- Date: Thu, 30 May 2013 06:00:35 +0000
Hi
> When adaptive cursor sharing is in action does the database peek the bind
> variables over and over again? i.e does the database find out the bind
> literal value in order to determine weather the cursor should choose one
> plan or another?
Yes, for bind-aware cursors it peeks the value(s) for every parse call.
HTH
Chris Antognini
Troubleshooting Oracle Performance, Apress 2008
http://top.antognini.ch
--
//www.freelists.org/webpage/oracle-l
Other related posts:
