Re: How to force Oracle generate a new execution plan

Hi Eriovaldo,

thanks for sharing the details.

The execution plan posted looks like the "bad" one since it has 21 bind variables. Can you also share the "good" one that you get when using 20 or less bind variables?

Or do you mean to say that (since you say "the execution plan") that you get the same execution plan in all cases but starts performing badly when greater 20 bind variables get used?

Ideally you would share both execution plans with Rowsource statistics enabled that show the actual rows / time / logical I/O etc. in addition to the optimizer estimates.

Randolf

Am 11.11.2016 um 19:35 schrieb Eriovaldo Andrietta:
> Randolf,
>
> Here is:
> The application retrives from database an accoaunt list. This list has
> from 1 to N lines.
> These lines are showed in the screen and the user choice 1, 2, 3 ...,
> 20, 21, ... n accounts to be processed.
> At this point the application mount a dynamic query to execute in the
> database like this:

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