RE: adaptive cursor sharing and bind peeking

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Thu, 30 May 2013 06:00:35 +0000
Message-ID: <43D812FCDBAB8948B2F14F61C4B1CD0A5AFE9D53_at_smxc002.trivadis.com>

> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 30 2013 - 08:00:35 CEST

This message: [ Message body ]
Next message: Saurabh: "Re: Need insight for RMAN tape backup troubleshooting"
Previous message: Radoulov, Dimitre: "Re: error from opatch installing Apr 2013 PSU"
Maybe in reply to: amonte: "adaptive cursor sharing and bind peeking"
Next in thread: amonte: "Re: adaptive cursor sharing and bind peeking"
Reply: amonte: "Re: adaptive cursor sharing and bind peeking"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message