Re: where 1=2

From: Johan Eriksson <valpis_at_gmail.com>
Date: Mon, 29 Jun 2015 20:53:33 +0200
Message-ID: <CABz5TyC8yOio03B4OGjSthWKzGrZUH+5BdoJ8pyZSYQX=y4oWA_at_mail.gmail.com>

from the v$sql_plan on 11.2.0.4
(:SYS_B_0<>:SYS_B_1 OR INTERNAL_FUNCTION("YFS_ORDER_LINE"."ORDER_LINE_KEY"))

Since that indicates that 1!=1 is present I did check the cursor_sharing on 11.2.0.3 : EXACT
11.2.0.4: FORCE which I think might explain the issue

On Mon, Jun 29, 2015 at 8:44 PM, Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk
> wrote:

>
> Since you can query ASH I assume you can also get the runtime execution
> plan.
> What do the two predicate sections say.
> If it's not cost the next obvious guess is NLS conversion or some other
> coercion issue.
>
>
>

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

Received on Mon Jun 29 2015 - 20:53:33 CEST