Re: Help me solve this cardinality puzzle

2008/4/18, Milen Kulev <makulev_at_gmx.net>:
>
> Hi Christo,
> Be aware of the fact, that on 10.2.0.3 there is bug related to bind
> peeking.
> In the secription of Bug 5082178 you will read:
> ---------------------------------------------------------------
> In some situations bind peeking can occur when it should not
> eg: Bind peeking can occur for user binds even if
> "_optim_peek_user_binds" is set to FALSE.
>
> This can cause binds to be marked "unsafe" leading to cursors
> not being shared when they should be.
> ---------------------------------------------------------------
> Full bug description you will find in ML:5082178.8.
> Oracle 10.2.0.3 is definitely one of the affected versions (although I
> have noticed the same
> Problem on 10.2.0.2 several times).
>
> The only relief is to go on 10.2.0.4 ...
>
> HTH. Milen
>
>
>
> Good info, but i don't believe this bug would show itself in "explain
plan".
Chriso, can you show us the DDL script for your table and index?

I believe that i've seen similar cases a couple of months ago, but didn't have time to investigate.
I tried to replay them but with no success.

Dion Cho

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