RE: adaptive cursor sharing and bind peeking
From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Fri, 31 May 2013 07:01:50 +0000
Message-ID: <43D812FCDBAB8948B2F14F61C4B1CD0A5AFE9FE5_at_smxc002.trivadis.com>
Hi
Date: Fri, 31 May 2013 07:01:50 +0000
Message-ID: <43D812FCDBAB8948B2F14F61C4B1CD0A5AFE9FE5_at_smxc002.trivadis.com>
Hi
> For all type of parses, hard, soft, softer?
As I wrote in my last reply, bind peeking is done for every *parse call*. In other words, every time a client asks the database engine to parse a SQL statement. It doesn't matter whether the database engine does a hard or soft parse.
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:01:50 CEST