Re: Help me solve this cardinality puzzle

  • From: "조동욱" <ukja.dion@xxxxxxxxx>
  • To: makulev@xxxxxxx
  • Date: Fri, 18 Apr 2008 09:08:22 +0900

2008/4/18, Milen Kulev <makulev@xxxxxxx>:
> 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

Other related posts: