RE: where 1=2

From: Jonathan Lewis <>
Date: Mon, 29 Jun 2015 19:23:22 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D9282984B5_at_EXMBX01.thus.corp>

That's correct - although the appearance of the internal_function() also suggests that there may be a further oddity to pursue (or that your c1 = '1' example was an over simplification).

Jonathan Lewis

From: Johan Eriksson [] Sent: 29 June 2015 19:53
To: Jonathan Lewis
Cc:; oracle-l-freelists Subject: Re: where 1=2

from the v$sql_plan on

Since that indicates that 1!=1 is present I did check the cursor_sharing on : EXACT<>: FORCE

which I think might explain the issue

On Mon, Jun 29, 2015 at 8:44 PM, Jonathan Lewis <<>> 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.

Received on Mon Jun 29 2015 - 21:23:22 CEST

Original text of this message