Re: Help me solve this cardinality puzzle

From: 조동욱 <>
Date: Fri, 18 Apr 2008 09:08:22 +0900
Message-ID: <>

2008/4/18, Milen Kulev <>:
> Hi Christo,
> Be aware of the fact, that on 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 is definitely one of the affected versions (although I
> have noticed the same
> Problem on several times).
> The only relief is to go on ...
> HTH. Milen
> Good info, but i don't believe this bug would show itself in "explain
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

Received on Thu Apr 17 2008 - 19:08:22 CDT

Original text of this message