Re: Setting bind variables or defines from applications?

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Sun, 23 Apr 2006 01:10:32 +0200
Message-ID: <e2ed5c$aer$01$1@news.t-online.com>

Sybrand Bakker schrieb:
> On 22 Apr 2006 08:29:56 -0700, "Keith" <keithhoxie_at_verizon.net> wrote:
>

>> If you search Tom Kytes web sitem he provides a good explaination and
>> examples with proof.  Its asktom.oracle.com.

>
> Yeah, everyone here knows Tom Kytes site is http://asktom.oracle.com
>
> But could you please come up with an exact link to support your bogus
> observations, or shut up forever?
>
> --
> Sybrand Bakker, Senior Oracle DBA

I think, he is speaking about some kind of optimization made in 10g which allows to recognize repeated "statical sql" being executed immediately and parse them only once, these examples are pretty reproducible (as usual by Tom Kyte ;-) ) http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:455220177497#39593642494581

Best regards

Maxim Received on Sat Apr 22 2006 - 18:10:32 CDT