Search My Oracle Blog

Custom Search

21 September, 2007

More on Bind Variable Peeking and Execution Plans

Here's how Tom Kyte used the example of a the mystery why a query with SQL_TRACE enabled seemed to perform better than the same query by itself --- because it was being parsed as two different queries when Bind Variable Peeking saw different values.
To the many responses about bind variable peeking, he further reviews some of the options.

1 comment:

Babu B said...

Nice Post..

Babu B
http://babudba.blogspot.com

Aggregated by orafaq.com

Aggregated by orafaq.com
This blog is being aggregated by orafaq.com