Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: USER_BIND_PEEK_MISMATCH...

Re: USER_BIND_PEEK_MISMATCH...

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 27 Jun 2007 15:04:29 +0100
Message-ID: <dtydnZ8e8fX38x_bnZ2dnUVZ8tKsnZ2d@bt.com>

"Elena Ivanova" <eivanova_at_web.de> wrote in message news:1182875119.091841.186920_at_m36g2000hse.googlegroups.com...
> Sometimes in one envoronment (the same init.ora, etc...) I see a lot
> of child cursors for the query with different execution plans. V
> $SQL_SHARED_CURSOR shows only USER_BIND_PEEK_MISMATCH='Y'.
>
> The oracle documentation sais: "Cursor is not shared because value of
> one or more user binds is different and this has a potential to change
> the execution plan".
> But we have always the same values of the binds, so I do not
> understand why we have sometimes 1 and sometimes a lot of child
> cursors.

There is some discussion on my blog:

    http://jonathanlewis.wordpress.com/2007/01/05/bind-variables/

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Received on Wed Jun 27 2007 - 09:04:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US