Re: Multiple SQL version count with cusror_sharing=similar

From: Neeraj Bhatia <neeraj.dba_at_gmail.com>
Date: Thu, 2 Jul 2009 13:22:20 +0530
Message-ID: <a8fd4d730907020052k17199ac3l502eb7c377ece7ab_at_mail.gmail.com>



Hi Tanel,

Thanks for the update. I am on 11.1.0.6, will upgrade and check the functionality.

One causual question, how you track version releases and check the functionality so quickly. It's really amazing.

Warm Regards,
Neeraj.

On Thu, Jul 2, 2009 at 3:21 AM, Tanel Poder <tanel_at_poderc.com> wrote:

> In 11.1.0.7 there's a new field HASH_MATCH_FAILED in v$sql_shared_cursor
> which covers the "unsafe binds due histograms with cursor_sharing=similar"
> problem case.
>
> --
> Tanel Poder
> http://blog.tanelpoder.com
>
>
>
> On Wed, Jul 1, 2009 at 4:39 PM, Rich Jesse <
> rjoralist_at_society.servebeer.com> wrote:
>
>> > BTW, while search in metalink, there are numbers of bug hits related to
>> the
>> > issue.
>> >
>> > Regards,
>> > Neeraj Bhatia
>>
>>
>>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 02 2009 - 02:52:20 CDT

Original text of this message