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


> 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.

Chris Antognini

Troubleshooting Oracle Performance, Apress 2008


Other related posts: